Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatically jump to top of the next column in a form
I created a three colum form for entering bar code data. How can I
automatically jump to the top of the next column when the last entry is made in the previous column? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatically jump to top of the next column in a form
Something like this should do the trick:
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If ActiveCell.Row = 21 Then Cells(1, ActiveCell.Column + 1).Select End If End Sub If you attempt to go past row 20 (i.e. row 21) the active cell starts at the top of the next column. "Arvin Wilson" wrote: I created a three colum form for entering bar code data. How can I automatically jump to the top of the next column when the last entry is made in the previous column? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to jump cells in column data when finding average, max and mi | Excel Discussion (Misc queries) | |||
how do I automatically jump to the present date in a roster? | Excel Worksheet Functions | |||
dislike jump bottom of column by double-clicking the bottom of cel | Excel Discussion (Misc queries) | |||
Need formula to jump from one column to the next | Excel Worksheet Functions | |||
opening a form automatically | Excel Programming |