Userform Textfield Data Entry Speed

[Berrywoods]

Im curious as i can implement it into what ive done so far and it would make my userform much easyier to use, at the moment you either scan (barcode) or enter code into my userform press enter, it searches Column B on sheet 1 for this value, and then if found highlights Cell A of that Row. It then runs a macro that prints to my label printer the data generated. Now some barcodes i have are longer than others so cant set the macro to call once a number of digits have been enterd. I ideally (for speed of printing) would like the Userform to call the macro to print once something has been scanned or if being enterd manually enter is pressed after.

My thoughts are the best ways to do so would be based on speed the digits are enterd, (if scanned, Digits would be enterd instantly wheres manually it would be typed slowly.) if anyone can point me in the right direction that would be great.

[Richard Buttrey]

Hi,

How are you getting the scanned code added to the workbook?

A macro which is triggered by the Worksheet_Change event in the appropriate column is probably the way to go but I'm intrigued as to how you are interfacing a scanning device with the workbook.

Rgds

[Berrywoods]

well my set up at the moment, when i add a product to my main master sheet, i goto the next avaliable row, click the EAN box, and scan the product with my scanner, it inputs the barcode as numbers into the column, when i print my shelf edge labels the label prints a code in code39. I know for example when you scan a product into my epos till, the barcode has a stop and start charcter which tells the epos system the code is finished, i dont know how possible this would be with the userform as when scanning say onto textbook it just dumps the numbers and not the start and stop characters. If i was to relabel everything in the shop with code39 labels i could (in thoery) add say a * to the start and end of every barcode and tell the useform to run macro once it has detected the second *, but this wouldnt work when scanning the actual product EAN (European version of UPC for anyone from USA)