Hello,
I am trying to create a barcode check for our end user to catch their mistake before they submit their excel file.
Userform1 : I have user enter SKU: # and Qty: # and button to go to next userform2.
userform2:
The Qty:# will be set as a limit on how many barcode can be scanned for
if user accidentally hit enter and a blank line is present have it return back
auto remove duplicate. if line matches up with any previous line auto delete
set limit to stop at 10 qty.
Barcode.JPGBarcode1.JPGBarcode4.JPG
user then finish hit the submit button and that transfer the textbox1 list to C8 and downwards.
I have also attached the excel file (not complete).
Barcodetestexcel.xlsm
Bookmarks