Bar code into a form

[Guest]

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?

 

[NickHK]

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

NickHK

 

[Guest]

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

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

NickHK

 

[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

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.

 

[Guest]

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

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.

 

[Guest]

Thanks guys!

 

[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>__<

 

[Dave Peterson]

There are worksheet and workbook events you could tie into, but I don't know how
the barcode scanner would affect them.

Chip Pearson has some instructions on events:
http://www.cpearson.com/excel/Events.aspx

David McRitchie has some notes, too:
http://www.mvps.org/dmcritchie/excel/event.htm

 

[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