MultiLine Textbox to auto remove blank line, count line, remove duplicate

[khhoa]

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

[khhoa]

Is there any other options to have error check automatically before submit?

[khhoa]

Bump no response

[khhoa]

Bump no response

[khhoa]

Bump no response

[jindon]

How about 2 in 1

Please Login or Register  to view this content.

[khhoa]

Thanks jindon it works fine.

The only issue I found is that the code allows to have a blank line for the line 1/first line in textbox1

[jindon]

Then try change to

Please Login or Register  to view this content.

[khhoa]

Thanks jindon, it work perfectly.


for those who need this is the limit code I have also added

Please Login or Register  to view this content.