VBA barcode scanning

Hi there,

I'm trying to code a spreadsheet to recognise codes scanned by barcode scanners. It would need to recognise one form of code (a letter followed by three numbers eg. A111), locate a cell with the matching code in it and select the cell to the right in the same row. Then with all other codes varieties, it would need to record that code into selected cells. Please help :-)

Thank you all! Have a lovely day.

Assuming your code is entered into cell A1, your barcode lookups are in cells B1:B10 and the matching codes are in C1:C10, put this formula in a cell on the same sheet;

Please Login or Register  to view this content.