Need help for barcode reader to have cursor jump to next row

[cprokop25]

Hi,

I have an Excel file programmed to work with a barcode scanner and I simply want help writing the code to have the cursor automatically jump from its current cell to the cell right below it after a barcode is scanned. All of the barcodes scanned are numbers that are 9 digits in length.

Thanks,
C. Prokop

[DataMiser]

Well the first thing to do is have the barcode engine pass a character as a suffix when a barcode is scanned.
In this case I would think that having a CR sent after the scan should do the trick, most barcode readers support this.

In any case this should not need any code at all and is not VB6 related.
You should check your documentation on the scanner to see what you need to do to have it send a CR after each scan.
Often this just requires scanning a configuration barcode from the manual.

[Zvoni]

I assume that the OP scans directly into a cell, so he can still do it manually if the scanner/barcode itself doesn't support CR

Private Sub Worksheet_Change(ByVal Target As Range)

    Me.Cells(Target.Row + 1, Target.Column).Select
    
End Sub

EDIT: I forgot! Careful with this, since this works also for cells changed by typing something in it. If you only want to use this on the cells you get input from the scanner, you have to trap the cells by checking with an If- or Select-Case-clause if it's a cell for which you want to jump one cell below