Log In
Register
Home
January 17, 2020
Offline
Problem with selecting worksheet/cells and inserting data
Hi All,
Code works as it should until I make another entry in the 'Inventory Booked In' worksheet.
What the code is not doing is when a 2nd entry is made it puts the data in the 'Inventory List' and puts data into the 'Scans with Dtae Time Stamp'.
It does this on a 1st entry but stops on a 2nd entry and doesnt work for any more entries made.Hope someone can help with this.
October 5, 2010
Offline
Hi Sean,
Your VBA is password protected. Can't open it to debug it.
Phil
January 17, 2020
Offline
My apologies I should have said that the password for unprotecting is summerscales. It's the same password for the vba properties
October 5, 2010
Offline
Hi Sean,
I don't really know what I am doing with this workbook. How exactly am I supposed to enter data into the Inventory Booked in Sheet? Using a barcode scanner?
When I go to the Inventory Booked in Sheet and double click a cell I get an Input Box that is in a loop asking me to scan a user id barcode, so I can't get out of it and have to kill Excel.
When you say the code works - how so? What do you define as working?
'When a 2nd entry is made' - how is this done?
Please be as clear as possible about what your code does, what you expect it to do and the issues you are having.
Regards
Phil
January 17, 2020
Offline
Hi Philip,
For the purposes of testing the keyboard can be used instead of a scanner.
When you double click on a cell it thinks there has been an entry made in the input box (f1) and then asks for the next but of info I require. The way to stop this happening at the moment is I have put a couple of macros in called 'Toogle on' and 'Toggle off' to run prior to making any changes to avoid what you have encountered.
At the moment with a completely empty clean workbook with no data in it the coding runs through nice and smoothly. It takes the 1st barcode entered, the user ID, the location and places them into the Inventory List and the Scans with Date Time Stamp sheets. The coding has then finished running until another entry is made in either the Inventory Booked In or the Inventory Booked Out sheets.
Now to the problem. The 1st set of info entered does everything it is supposed to do in respect of populating the other worksheets.
When any more entries are now made the coding seems to not run correctly or the same way it did with the 1st set of entries as in it does not populate the other worksheets with the relevant info.
Hope that all makes sense Philip.
October 5, 2010
Offline
Hi Sean,
Your calling the sub FindLastCellAddy to find the next row to add data to? This sub is returning the address $F$11635 so I'm thinking that your code is writing data to the sheets, but it's doing it to a place you are not expecting so you think it's not working.
Try stepping through your code to see what it is doing
Regards
Phil
1 Guest(s)
