Cell Tab Order

[hjcrooks]

Hi, I have a spreadsheet that is used to collect serial numbers from 2 components and they are entered in A1 and B1 with C1 being used to confirm that they are the same. I want my tab order to automatically go A1, B1, A2, B2, A3, B3....A2500, B2500. Can anyone help me achieve this? The serial numbers are entered from a Barcode Scanner. Thanks in advance Jim

[Tinbendr]

Welcome to the board!

This works with my hand scanner.

In the sheet code page in question.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
Target.Offset(, 1).Select
End If

If Target.Column = 2 Then
Target.Offset(1, -1).Select
End If

End Sub