ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   move cursor after inputting data without using enter key (https://www.excelbanter.com/new-users-excel/146174-move-cursor-after-inputting-data-without-using-enter-key.html)

[email protected]

move cursor after inputting data without using enter key
 
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

move cursor after inputting data without using enter key
 
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


" wrote:

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.



Bernie Deitrick

move cursor after inputting data without using enter key
 
js,

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

http://www.softwarewedge.com/

HTH,
Bernie
MS Excel MVP


wrote in message
ups.com...
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.





All times are GMT +1. The time now is 06:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com