How to Move Barcode Scanner to Next Row in Excel (2 Ways)

Barcode scanners are devices that receive, interpret, and send data from barcodes. It serves a really simple purpose. Barcode scanners, although they may appear straightforward, are actually quite helpful for any company. Microsoft Excel has a useful function that allows you to save barcodes in individual cells. In this article, we will demonstrate how to move the barcode scanner to the next row in Excel.

How to Move Barcode Scanner to Next Row in Excel: 2 Ways

Utilizing a sequence that a system can read, barcodes are utilized to encrypt data. Barcodes can monitor items, costs, and inventory levels enabling central recordkeeping in computerized software products, among other things. While working with barcodes it does not move to the next row properly in Excel. So let’s look at the ways to move the barcode scanner to the next row in Excel.

1. Utilize Excel Options to Shift Barcode Scanner to Next Row

Using data from a range of cells as input, a formula in Excel performs an operation. These equations nonetheless provide a result, even if it’s erroneous. With the use of Excel formulas, we can execute operations like addition, subtraction, multiplication, and division. Also with an Excel formula, we can input the barcode. Let’s follow the instructions to do this.

STEPS:

Firstly, go to the File tab from the ribbon.

This will take you to the backstage menubar of the Excel file.
Secondly, scroll down a bit and click on the Options menu.

Thus the Excel Options dialog box will appear.
Now, go to the Advanced option.
In the Editing Options group, check mark After pressing Enter, move selection.
And select the direction Down from the Direction drop-down menu.
Further press the OK button to complete the process.

Then, select the next row where the barcode is located, to move the barcode. In our case, we select cell C5.
After that, write down the formula for that cell.

="("&C4&")"

Furthermore, press the Enter key from your keyboard.

Go to the Home tab from the ribbon, and make sure you are selecting the cell.
Subsequently, under the Font category, select the font IDAutomationHC39M.

Note: If you do not have that font in Excel, download the font. This font is available in Google.

Finally, you can see that the barcode scanner moves to the next row of the code.

2. Apply Excel VBA to Move Barcode Scanner to Next Row

With Excel VBA, users can easily use the code which acts as an Excel menu from the ribbon. Let’s follow the procedure to use the VBA code to move the barcode scanner to the next row.

STEPS:

Firstly, go to the Developer tab from the ribbon.
Secondly, click on Visual Basic from the Code category to open the Visual Basic Editor. Or press Alt + F11 to open the Visual Basic Editor.

Instead of doing this, you can just right-click on your worksheet and go to View Code. This will also take you to Visual Basic Editor.

And, this will open up the visual basic window.
After that, copy and paste the VBA code below.

VBA Code:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column = 3 Then
        Target.Offset(0, 1).Select
    ElseIf Target.Column = 3 Then
        Target.Offset(1, -1).Select
    End If
End Sub

After that, save the code by pressing the Ctrl + S key from your keyboard.

Code Explanation

Private Sub Worksheet_Change(ByVal Target As Range)

Sub is a part of code that is used to handle the work in the code but will not return any value. It is also known as subprocedure. So we name our procedure

If Target.Column = 3 Then
Target.Offset(0, 1).Select
ElseIf Target.Column = 3 Then
Target.Offset(1, -1).Select
End If

Start by moving from cell C4 to cell C5 and selecting cell C4 using the If Else statement and Offset property. Finally, go to the following line in the C5 cell by using the Offset attribute.

End Sub

This will end the procedure.

Note: You don’t need to change the code. All you can do is just change the range as per your requirements.

The barcode may then be moved by selecting the subsequent row where it is situated. In this instance, we choose cell C5.
Write the formula into that cell after that.

="("&C4&")"

Press the Enter key on your keyboard once more.

Make sure you choose the cell when you go to the Home tab on the ribbon.
Likewise, in the previous method, select the font IDAutomationHC39M from the Font category after that.
The barcode scanner finally moved to the following row of the code, as you can see.

Things to Remember

Our ideas aren’t appropriate for our purpose or location, the scanner isn’t working correctly, or our equipment isn’t matched to barcodes.
A start, stop, or check digit that is absent or entered incorrectly is the most frequent reason for a barcode typeface to refuse to scan.
A unique start character, termination personality and the majority of barcode typefaces also call for a computed check digit. Verify that the barcode fonts are being printed in the appropriate format.

Download Practice Workbook

Move Barcode Scanner.xlsx

Conclusion

The above ways will assist you to Move Barcode Scanner to Next Row in Excel. Hope this will help you! Please let us know in the comment section if you have any questions, suggestions, or feedback.

<< Go Back to Use Barcode Scanner | Barcode in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!