Thread: Barcode validation

what I am after is that there is an 'interface' section at the top with a Y/N/X field and a blank spot next to it for scanning
its larger and easier to see, and resides in columns D and E (but could be anywhere to be honest)

then in column A you have the 'database' of barcode numbers with a blank next to it in cloumn B

What I want to happen is that when you scan a barcode into column E, it will look at column A and return a Y or N to column D

If its a yes, it needs to mark the field in column B with an X

that way the next time you scan the same number into column E, it will return an X instead of a Y or N

Make sense?


Y/N BARCODE
N

BARCODE SCANNED?
5
6
7
8
13
14
15
16
104
105
106
107
108
505
506
507
508

that looks very close to what I need but is there a way to for it show the Y for a longer amount of time before it changes to an X?

and is there a way for it to reset back to the 'barcode' field without having to arrow up and press delete (or type over it)

Thanks...that's awesome...

only one small issue

is there a way to insert a pause or something between the time it changes from a Y to an X?

as it is, its too fast that someone scanning the barcodes in would not know if it went from Y to X or was just an X the whole time

Sorry, I uploaded the original again by accident. Here is the revised spreadsheet.

Hmm...I really like that solution, not to much hassle to hit enter again

Could hitting enter jump back to 'home' and delete the number rather than just jumping back?

Try this. I've added two functions. One that will pause it for however long you want, and the other to hit enter to continue. It will also now clear E3. To make the adjustments for pausing or hitting enter follow these steps:

1) Hit alt+f11
-- If you want it to pause, put an apostrophe in front of 'MsgBox ("Hit enter to continue")' (This is how it is now)
--TimeValue("00:00:02") will pause the program for 2 seconds. Adjust this to your preference.
-- If you want to hit enter to continue, put an apostrophe in front of Application.Wait Now + TimeValue("00:00:02")

Ok, this is the best so far...but it stopped working as far as if the number is scanned in again while the b column has an X in it, all it does is blank the field and still say 'N'

Side note, thank you very much for all your help...where did you learn so much about Excel?

Homebuil, thanks so much

Only one small issue...

The 'X' if something had already been scanned seemed to work in the first revised version but didn't in revised(1)

Revised(1) is perfect as far as I can tell other than that small thing

Does this work better?

Excellent!!

Thank you so much...

If you enter a number that has been already scanned, it displays an X and doesn't blank the field after that. At first I didn't know if I liked it that way, but now that makes sense because it will make you look for whats wrong, rather than just continuing


Since this is all macro or VB based, I don't need to worry about how long the list is right? I mean there's no formula to worry about copying right?

Thanks so much again...where did you learn all this?

You're welcome. No, don't need to worry about how long the list is. The program will count non empty cells in column A.

One small issue

some of the tickets have a 'V' in front of a number for VIP guests

the spreadsheet doesn't seem to work with those

any ideas?