After scanning a barcode how can I automatically move to the next.

[Guest]

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.

 

[L. Howard Kittle]

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