View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
bigwheel bigwheel is offline
external usenet poster
 
Posts: 222
Default 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?