Using a barcode scanner with Excel

Mr_Mod · May 12th 2016

Hi All,
I am looking at a way to use a handheld bar code scanner and input the data into a worksheet.
What i need to do is the following
1: Scan cabinet serial number into cell C3 (9 characters in total for serial number)
2: Scan module 1 serial number into Cell D3 (12 characters in total for serial number)
3: Scan module 2 serial number into Cell E3 (12 characters in total for serial number)
each time the serial number is scanned i want to automatically jump to the next column and enter the serial number and jump to next column

once i have those 3 items scanned i then want to jump down to the next row and continue doing the same.

I know there has to be some VBA code here but i have no clue where to start.

Can someone help me out please

rollis13 · May 12th 2016

Re: Using a barcode scanner with Excel

Have a try with something like this (start with cursor in cell C3). To be tested because I don't have a scanner.
Place it in the sheets VBA module.

Code

Option Explicit


Private Sub Worksheet_Change(ByVal Target As Range)


    Select Case Target.Column
        Case 3                              'column C
            If Target.Value <> "" Then
                Target.Offset(0, 1).Select  'move right
            End If
        Case 4                              'column D
            If Target.Value <> "" Then
                Target.Offset(0, 1).Select  'move right
            End If
        Case 5                              'column E
            If Target.Value <> "" Then
                Target.Offset(1, -2).Select 'move down and back to column C
            End If
    End Select


End Sub

Display More

Using a barcode scanner with Excel

Participate now!

Share