barcode reader and userform

[depcdivr]

Has anybody integrated a barcode reader into a userform? I want to create a checkout type program using a barcode reader. I have the program already in place but was curious as to how to go about using the barcode scanner.

Looking for some advice.

 

[jpfaff]

Hi,

Are you looking for something to create bar codes, or are you looking to have someone scan a barcode into a field within a userform?

If the later is true, most scanners are simply keyboard emulators, and will input the value of the barcode into the field upon a successful scan. For example, if the UPC of the barcode is 12345, and you scanned the barcode, it would input 12345 in the same way it would if you were to type it directly in with a keyboard.

 

[depcdivr]

I was looking for the latter. I want to be able to scan a barcode and have it enter information into a userform.

Do you know if there is a way that can activate some VBA code when the barcode is scanned.

I know that you can do it with a button or with key stroke. Is there a way to do it with the barcode reader.

 

[diddi]

barcode scanner scans directly to a string, so as long as the focus on the form is something text compatible, like a txtbox, then no special code is needed. i have used barcode recognition in form often.

 

[NickRed18]

diddi,

I'm only 4 and a half years late replying, but I came across this thread while researching for my current barcode project.
I'm curious where exactly the barcode scanner will drop its code that it scans. I know it acts as if the user would enter in the code manually, but lets say I have another window open and I scan a barcode. I'm on google or where ever, and I also have my workbook minimized. If I were to scan the barcode while still on google, the code would be inserted into the google search box (or that is my assumption). How can I have it to where whenever a barcode is scanned, no matter what window I am currently using, it is only inserted into my excel userform?