Bar code scanning

I am using a scanner to import the numbers associated with bar codes. The numbers are always the same length at 20 characters. When the bar codes are scanned this has to be followed by hitting the enter key to move to the next row. Scan, enter, scan, enter......
This becomes repetitive and missing the "enter" key will result in 2 entries on one line. On average 20,000 of these are scanned in a day.

What I would like to do is this:
I would like to just scan the item and have the highlight move to the next row thus eliminating the need to hit the enter key. Can this be done? I have tried simple macros to no effect and have struck out trying to limit the amount of data the field will accept.

Any thoughts, suggestions or help would be greatly appreciated.

Originally Posted by Steffen Thomsen

Then try something like this in the sheet module.

This assumes it's column a that stores the data

Please Login or Register  to view this content.

Let's assume that I am a complete xcel noob. I have tried copying and pasting this into a module and have had a complete fail so I am going to ask for you to go the extra mile and walk me through this. Don't think I haven't googled this to avoid the humiliation and found some good tutorials but I am falling flat.