[SOLVED] Forms: wait until textbox string is finished with a return key before a vlookup

Hiho,

We want to use a barcode scanner to help with our inventory management.
When scanning, the scanner actually 'types' in keys followed by the enter key. (i.e. "Big box of bolts")
With a custom form I want to scan a barcode, then perform a lookup to find item information. (i.e. "These are M10 bolts made from steel")

Since there are many inventory items, I want minimal use of keyboard and mouse for the operator.
A custom form will do the job!

I want to let the barcode scanner fill out a textbox, and then use this value in a lookup to find the other information.

This is what I do now:

ScannedItem = TextBox1.Text

ScannedItemDesc = Application.VLookup(ScannedItem, Worksheets("Data").Range("a2:f450"), 3, False)

The problem is, it will do the Vlookup after each entered character that is placed in the textbox. It doesn't wait for the enter key to be pressed to 'confirm' the entry.

So it doesn't wait for "Big Box Of Bolts" to be entered, it will see "B" and try to look that up.

How can I make the textbox more patient so it only goes ahead with the lookup after it actually recognizes a text being completed by the enter key?

Cheers!
Niels