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