ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Barcode Scanner and macro question (https://www.excelbanter.com/excel-programming/316084-barcode-scanner-macro-question.html)

Johnsey[_5_]

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


crispbd[_22_]

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