Hopefully a SIMPLE macro

[brettd03]

I've had succes with responses here in the past, so I thought Id give it another shot!

I have a 3 column spreadsheet. I will be scanning barcode information (for example) into A1 then B1 then C1. After that, drop down to A2, scan, B2, C2, drop to A3 etc.

I have the Symbol scanner programmed to send "tab" after each scan right now. So, the left to right is working fine. My only dilemma is sending an "enter" to drop to the next row after 3 scans.

I dont believe I can set the scanner for 2 arguments, so my best guess was a macro?

Any ideas?

 

[AlphaFrog]

• Unhide column D
• You can reduce column D's width down to 1 pixel if you want, but it has to be unhidden for this to work.
• Right-click on the sheet tab and select View Code from the pop-up menu
• Paste the code below in the VBA edit window

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Column = 4 And Target.Row < Rows.Count Then
        Application.EnableEvents = False
        Range("A" & Target.Row + 1).Select
        Application.EnableEvents = True
    End If
End Sub

You would Tab to the D cell after scanning in the value in column C. The code basically automatically selects the next cell in column A when you select any cell in column D.

 

[brettd03]

Worked like a charm!

Thanks a bunch!