Bar code into a form

J

Jennifer

Hey guys,
I have a code that when I use a bar code scanner it drops the code into a
cell say A1. I would like the bar code to be directly dropped into a text box
in the user form I have made in VBA. Any sugestions?
 
J

Jennifer

Do you think you could explain just a bit more. I know how to make for example
txtbarcode.setfocus but I'm not sure how to direct it to scan directly into
the txtbox. It just keeps going into cell A1. Thank you Nick. I will keep at
it.
--
Though daily learning, I LOVE EXCEL!
Jennifer


NickHK said:
Jennifer,
Make sure that text box has the focus when you scan the barcode.

NickHK
Click to expand...
 
N

NickHK

Jennifer,
Assuming you are using a barcode scanner with a keyboard wedge, it just
emulates keyboard input.
So if your txtbarcode has the focus, the barcode number should end up in
that text box.
You are not doing some .Select of A1 after showing the userform ?

NickHK

Jennifer said:
Do you think you could explain just a bit more. I know how to make for example
txtbarcode.setfocus but I'm not sure how to direct it to scan directly into
the txtbox. It just keeps going into cell A1. Thank you Nick. I will keep at
it.
Click to expand...
 
J

Jason

textbox.text = worksheets("ursheet").range(A1).value
worksheets("ursheet").range(A1).value = ""


Jennifer said:
Do you think you could explain just a bit more. I know how to make for example
txtbarcode.setfocus but I'm not sure how to direct it to scan directly into
the txtbox. It just keeps going into cell A1. Thank you Nick. I will keep at
it.
Click to expand...
 
S

Steve

Dear all,

A barcode scanner operation will follow by a Enter, is it possible to use
this Enter to trigger a Sub?

Please help>__<
 
T

Thomas Lutz

If you use a bar code scanner that connects to a RS232 serial port,
you would be able to use a software product called WinWedge to input
the data from the bar code scanner and then trigger a VBA subroutine
in Excel to run each time a bar code has been scanned. The subroutine
would then be able to use the DDERequest function to retrieve the bar
code data from the WinWedge software.
For more information about the WinWedge product, visit www.taltech.com
 
Top