Using a barcode scanner and UPC master sheet for Inventory Control

**jlucas** · 09-19-2011, 01:08 PM

Hey Guys!

I'm trying to set up an automated inventory management system using a barcode scanner. Here is what I'm looking for:
Starting with sheet 2 ("Inventory"), I want a simple Userform that takes the input (scanned UPC) and finds that in the UPC Column. A quantity of 1 is added to the corresponding QTY Column, and then the input box is emptied. If no match is found for the scanned UPC, then I want it to highlight the UPC on sheet 1 ("Master List"), then add the UPC and a quantity of 1 to sheet 3 ("TO BE ADDED"). If it could also pull the price from sheet 1 and add that to sheet 3 as well, that would be great, but the highlighting could serve the same purpose. Does this sound do-able?

Here are some related posts:
http://www.excelforum.com/excel-gene...ode-input.html --This is the barcode scanner which adds a quantity
http://www.excelforum.com/excel-prog...-barcodes.html -- this is the Scan mode type button.

Thanks in advance!

**jlucas** · 09-20-2011, 03:33 PM

I have decided that I was making things too complicated with this idea. I have since simplified everything to one worksheet containing the UPC codes and a quantity column. I have made some progress with marrying the two ideas referenced but I am now getting a 424 error.
I don't understand why the worksheetfunction.countif() works when it is part of the UserForm Code, but seems to be failing when it is part of the module.