Thread: Automatic update of Inventory using barcode input...

I run a small business. I want to start keeping track of inventory using a barcode system.

I know Excel "ok", but I don't know programming.'

I'd like to be able to do something very simple (for now)...

For example...if I had PRODUCT / CODE / INV VALUE

A - CODE A - 5
B - CODE B - 11
C - CODE C - 14

I would want to be able to click a button (or scan a code for) : ADD +1 or REMOVE -1

...then scan the barcode on the product (A) and have it add or remove one, respectively. So, if the row for A is:

A - CODE A - 5

I choose "ADD" (with a button or scan code), then scan the barcode, and the spreadsheet automatically finds the code in the sheet, and changes the corresponding inventory value:

A - CODE A - 6

Does that make sense? How might I go about doing that?

Originally Posted by mrice

Please see the attachment.

You will find the main code by hitting Alt F11. The code relating to the buttons can be seen by hitting F7 wher the userform is displayed in the VBA editor.

Absolutely perfect! Thanks. I will review the code and learn what's going on.

You are a gentleman and a scholar!!!!

i want to use this book1 but my barcode scanner will input upc string in textbox and then click enter, this worksheet dosent accept this. i would like to know how, or perhaps u could do it, to have the scan box stay open and simply run the code when enter is pressed, then the textbox cleared and we start over.....could you help me?

so i got it working acording to what i asked...or so i think


not all the product upc codes work...only many of them....

why do you think not all of them work?

i havent a clue

Hey guys I'm not much of an excel user so I'm having a bit of trouble with using these pre-made excel sheets, every time I scan I get a pop up message saying "CODE NOT FOUND" can you please help me out with this? Thanks