Excel and Barcodes

How does this sound.

Before scanning you enter into a "Scan" mode.

My suggestion is to use a simple Userform. We can set the focus on an input box.

As long as it remains empty, nothing happens.
When scanned, the code is copied to a Worksheet and the input box is emptied again.

How does that sound?

Here's what I got. Now need to get some sleep.

Try it out and let me know what your results are.