Barcode Scanner and macro question

  • Thread starter Thread starter Johnsey
  • Start date Start date
J

Johnsey

Does anyone know if you can use a barcode scanner in Excel to convert a
barcode into numbers? If you can how do you do it?

I've got this macro but only want it to print the date when the column
it checks is yes

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
Application.EnableEvents = False
Range("G" & Target.Row).Value = Now()
End If
Application.EnableEvents = True
End Sub
 
A simple barcode reader / keyboard wedge will convert the barcode int
text just as if it were typed directly from the keyboard
 
Back
Top