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?

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?