Home |
Search |
Today's Posts |
#1
|
|||
|
|||
After scanning a barcode how can I automatically move to the next.
After scanning a barcode in excel, how can I automatically move to the next
cell without pressing the tab or enter key? Will be scanning multiple items from a distance of serveral feet from the keyboard. |
#2
|
|||
|
|||
Hi Tbledsoe,
When you say you are scanning a barcode in Excel, are you swiping a card in a barcode scanner and an identification number or a persons name is entered in the cell in Excel? I don't have a scanner but have written some code for a school admin person that matched a swiped ID cards bar code number to a students ID number and then listed the date and time the student entered the school. This scanning method acted the same as if you had manually entered the ID number in the cell and hit ENTER, the ID number in A1 and then A2 was selected. The scan moved the cursor down one cell. This allowed me to use the WorkSheet Change event to run the macro to match up student ID number with a student name. I read your post as if the cell is still in edit mode after the scan and you want an auto-enter method. I don't think you can do anything until you get the cell out of the edit mode. HTH Regards, Howard "tbledsoe" wrote in message ... After scanning a barcode in excel, how can I automatically move to the next cell without pressing the tab or enter key? Will be scanning multiple items from a distance of serveral feet from the keyboard. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move Data Table? | Charts and Charting in Excel |