How do I set excel to automatically advance to the next cell?
 

i have set up an inventory page for scanning out and back in converter boxes.
At this time, after I scan a box, I have to hit enter, tab or use the arrow
keys. Is there a way to have the cell automatically advance after I scan the
serial number with a scan gun?

How do I set excel to automatically advance to the next cell?
 

If I understand correctly ...

Using the worksheet module , depending on your input range you should
adapt following event :

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Offset(1,0).Select
End Sub

HTH
Carim


--
Carim
------------------------------------------------------------------------
Carim's Profile: http://www.excelforum.com/member.php...o&userid=33259
View this thread: http://www.excelforum.com/showthread...hreadid=531117