| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Excel automatically insert current date in a cell? | Excel Worksheet Functions | |||
| can excel automatically enter the date data in a cell was entered | Excel Worksheet Functions | |||
| Automatically date cell in Excel | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Can Excel add a set percentage to a cell automatically when you type in a number | Excel Worksheet Functions | |||
Linear Mode
