Barcode Scanner and macro question
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 |
Barcode Scanner and macro question
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 |
All times are GMT +1. The time now is 11:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com