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.
Download Practice Workbook
You can download the workbook and practice with them.
2 Effective Ways to Move Barcode Scanner to Next Row in Excel
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.
- Finally, you can see that the barcode scanner moves to the next row of the code.
Read More: How to Add Barcode Font in Excel (Installation and Application)
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.
- 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.
Read More: [Solved] Barcode Scanner Not Going to Next Line in Excel
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.
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. Or you can glance at our other articles in the ExcelDemy.com blog!
Related Articles
- How to Use EAN 13 Barcode Generator in Excel (2 Easy Ways)
- Calculate Barcode Check Digit with Excel Formula
- How to Make Auto Enter with Barcode Scanner in Excel
- Use Barcode Scanner for Inventory in Excel (with Easy Steps)
- How to Generate Barcode Numbers in Excel (with Easy Steps)
- Generate Code 128 Barcode Font for Excel (With Easy Steps)
- How to Use Code 39 Barcode Font for Excel (with Easy Steps)