inventory assistance

hi,

Here's a rough untested starter based on a quick google...
http://www.google.co.nz/search?sourc...arcode+scan%22

I don't know how Excel recognises when you have scanned an item but if it displays a text box you could modify the code in the below link to use either the "length of textbox" or the "ontime" approaches.
http://www.ozgrid.com/forum/showthread.php?t=40816

When modifying the code to suit your spreadsheet layout/ranges etc you could include something like:

'instead of
               c.Select 
                 '     Add'l code here
'try...
Dim CorrectSOHAmnt As Long
CorrectSOHAmnt = InputBox("What is the correct SOH of item " & c.Offset(0, 1) & " (" & c.Value & ")?" & _
            Chr(35) & Chr(35) & "nb: the current recorded amount is " & c.Offset(0, 2).Value & ".", _
            "PLEASE ENTER THE CORRECT SOH AMOUNT.", c.Offset(0, 2).Value)
c.Offset(0, 2).Value = CorrectSOHAmnt
' Please note I haven't included error checking for times when the inputbox is
'cancelled. Also, I hope the line wrap in this code is okay.

Also, note the potential issues if your barcodes are longer than 15 digits:
http://www.tech-archive.net/Archive/.../msg01132.html


hth
Rob

hi,

I'm sorry, it's a bit over my head too b/c I have no experience with software for barcode scanners. I've just googled using a couple of keywords & found the info. I guess the questions are...
1 Do you already have a barcode scanner?
2 If so, does it enter the scanned barcode digits into an Excel spreadsheet?
3 If so, what format does the info appear in?

I'm sorry I can't help any further (although others may be able to...?) until you can say yes to the above 2 questions. Once the info is in a spreadsheet I can have go at dumbing it down if needed but I suggest you thoroughly read your software manual (save having to reinvent the wheel) & also Google a few key words (including your software package name).

btw, a couple of other threads that I have just read by googling "barcode scanner excel inventory" suggest that a different approach is to have a macro increment the amount listed in the file each time you scan. In other words, you just scan a barcode xyz times & the spreadsheet will automatically increase (or change) the amount that is listed by xyz amount.


Rob