title: VBA Excel Code Barcode Scanning
body: <p>I have this excel spreadsheet and I'm using a barcode scanner, every time I capture something with the barcode scanner the cursor skip one column. </p>
  
  <p><img src="https://i.stack.imgur.com/N2H5L.jpg" alt="enter image description here"></p>
  
  <p>For example at A3 cell the info is capture so the cursor will move to C3, at C3 I capture another barcode and the cursor will move to E3 and so on; once is at G3, should go back to A4 to capture another box.</p>
  
  <p>This is the code that I have.....</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  On Error GoTo Whoa
  
  Application.EnableEvents = False
  If Not Target.Cells.CountLarge &gt; 1 Then
      If Not Intersect(Target, Columns(1)) Is Nothing Then
          Target.Offset(, 1).Select
      ElseIf Not Intersect(Target, Columns(2)) Is Nothing Then
          Target.Offset(, 1).Select
      ElseIf Not Intersect(Target, Columns(3)) Is Nothing Then
          Target.Offset(, 1).Select
      ElseIf Not Intersect(Target, Columns(4)) Is Nothing Then
          Target.Offset(, 1).Select
      ElseIf Not Intersect(Target, Columns(5)) Is Nothing Then
          Target.Offset(, 1).Select
      ElseIf Not Intersect(Target, Columns(6)) Is Nothing Then
          Target.Offset(, 1).Select
      ElseIf Not Intersect(Target, Columns(7)) Is Nothing Then
          Target.Offset(1, -6).Select
      End If
  End If
  Letscontinue:
      Application.EnableEvents = True
      Exit Sub
  Whoa:
      MsgBox Err.Description
      Resume Letscontinue
  End Sub
  </code></pre>
  
  <p>It works when I do it manually (without the scanner) but using the barcode scanner it returns to column B.</p>
  
  <p>For example at G3 I capture the date with a barcode and then it moves to B4 and not to A4 so I can start scanning the second box.</p>
  
  <p>I need some help to develop the right code so I can use my scanner to capture the inventory at my small warehouse</p>