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


--
Johnsey
------------------------------------------------------------------------
Johnsey's Profile: http://www.excelforum.com/member.php...o&userid=15560
View this thread: http://www.excelforum.com/showthread...hreadid=276389

A simple barcode reader / keyboard wedge will convert the barcode int
text just as if it were typed directly from the keyboard

--
crispb
-----------------------------------------------------------------------
crispbd's Profile: http://www.excelforum.com/member.php...fo&userid=1088
View this thread: http://www.excelforum.com/showthread.php?threadid=27638