barcode scanner only to input data into a cell

[TJPsmt]

Is there a way to limit the input of data to a barcode scanner only? I am having an issue with employees manually typing in information rather than scanning when there is an issue with the barcode. Our end customer uses this barcode for their internal data so we need to make sure it scans and reads correctly.

 

[Skyybot]

There is no way to limit input to Scanner only. The computer, therefore, the program you're using, sees Scanner input as Keyboard input. There is, however, a way to keep employees from entering incorrect UPC's but it is somewhat labor intensive and may require a complete overhaul of your Workbook (I'm assuming that they are scanning data into Excel, otherwise why would you post your question here).