Hi Guys,
I have a code in userform which I use to transfer data from one sheet to another when the barcode is scanned into the userform textbox(txtOrder), the barcode with order number contains 6 digits .
I have another textbox in userform called txtOperator, this textbox is also filled when scanning the barcode but now it contains only two letters.
So my issue is if not correct textbox is selected by operators it my cause barcode to scan into wrong textbox, lets say that order number will be scanned into operators textbox(txtOperator) and off course it could be in opposite way.
This is what i would like to achieve:
http://www.ozgrid.com/forum/showthread.php?t=193782
http://www.mrexcel.com/forum/excel-q...ml#post4108698
1.txtOperator textbox - Check if barcode contains 2 letters and if it is true leave it in a txtOperator textbox, but if it's more than 2 scan into txtOrder
2.txtOrder textbox - check if barcode contains more than 2 letters and if it is true leave it in txtOrder textbox, but if it's equals 2 letters scan into txtOperator
Below is my code and i also attached the file.
Thanks in advance for your help.
Bookmarks