Excel - barcode entry help

[deevaetodin]

Hi all..

I am entering in data a single column using a barcode reader to enter the value into the cell.

In order for me to go to the next cell below it I need to press enter and then scan the next barcode.

Is there anyway to set some formatting on the entire group of cells to indicate that once a value is scanned into the cell it will automatically move to the cell below it thus replacing the need to hit enter after every scan.

Any help is appreciated.

Thanks in advance.

D.

 

[SkipVought]

D.

Key these characters into A1...

12345678

Now, wait for {ENTER} to somehow happen.................................

waiting....................................

waiting.......................................

;-)

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[bluedragon2]

Hey Skip, not sure about the VBA aspect of it, but can you do a search on that column for the next available blank cell and select it on some kind of change event?



[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[SkipVought]

Blue,

What I was trying to point out is that unless the scanner device sends a CRLF at the end of the scan, its just like entering data in a cell WITHOUT HITTING ENTER.

Excel is waiting for another keystroke! "Please send [ENTER]!"

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[bluedragon2]

Yeah, I figured that. Just askin

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...