Bar Code Reader To Reduce Stock Level

It could be done with a macro. The scanner itself is pretty much just like a keyboard entry. It just types what it scans.

It all depends on how you want to trigger the macro from the scanner input and interface with it. You could scan into a specific "entry" cell, then use the Worksheet Change event procedure to trigger the macro to lookup the item and adjust the inventory. Or have an Input Box prompt or a UserForm to receive the scanner entry instead of a specific cell.

Sorry Alpha, could swear when I started there were no replies yet... I pretty much duplicated what you said.

Originally Posted by Arkadi

Sorry Alpha, could swear when I started there were no replies yet... I pretty much duplicated what you said.

Great minds think alike.

Originally Posted by AlphaFrog

Great minds think alike.

Or is it Fools Seldom Differ? haha

I would think a textbox with an exit event would combine great with the scanner, since they are usually set up to tab or enter after the scan. The textbox change event could then have the code to take the entered code, reduce its quantity by one, and then just activate the textbox again. A worksheet with a change event could do this fairly easily too, so long as the range is specific to avoid inadvertent changes.

timbo, no problem. Truth is you don't need the reader to put together the code. All the reader normally does is emulate keyboard input, followed by a suffix (typically enter or tab). Is the idea to scan the value in a cell? or do you want a textbox or a userform for the scanning? What you do need is the excel book he already created so you can work with that.