New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Scan checkout and checkin and match in excel

Macros, VBA, Excel Automation, etc.

Scan checkout and checkin and match in excel

Postby elopez72 » Tue Apr 26, 2016 12:21 pm

Hello,

My problem is similar to
Scanning barcode, match in excel
posted by a memeber here back in 2012.

I got a barcode scanner attached to a laptop. In my excel sheet, column A has check out barcode, column B has item to check in barcode. I have a barcode label (checkout#) on each item, so when I scan the barcode label, excel imputs checks out barcode in Column A and when checked in, it scans to column B, it will turn green for match and red for not matching on column C. Can anybody PLEASE help me with this using VBA macro.
Thanks
  • 0

elopez72
Rookie
 
Posts: 1
Joined: Apr 26, 2016
Reputation: 0
Excel Version: 2007

Re: Scan checkout and checkin and match in excel

Postby NoSparks » Tue Apr 26, 2016 4:27 pm

  • 0

NoSparks
Excel Hobbyist
 
Posts: 637
Joined: May 28, 2014
Reputation: 103
Excel Version: 2010


Return to Macros and VBA Questions

Who is online

Users browsing this forum: Google [Bot] and 46 guests