move cursor after inputting data without using enter key

[jsnelson]

I am using a scanner that reads barcodes and automatically enters data
into a cell. The problem is that I'm not always close to the computer
and want to have the cursor automatically go to the next cell after i
scan one code without having to press enter after every scan. Is there
a module or marco that can do this.

 

[Elkar]

This is not something that Excel could do. Even an event-driven macro
couldn't be triggered until cell editting is completed (when ENTER is hit).

However, you should be able to configure your barcode reader to
automatically append an ENTER (or Carriage Return) to the end of every scan.
Look up help on your specific barcode reader to find out how to do this.

HTH,
Elkar

 

[Bernie Deitrick]

js,

You might need to use a third party program like Software Wedge:

http://www.softwarewedge.com/

HTH,
Bernie
MS Excel MVP