![]() |
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. |
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. |
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