Results 1 to 9 of 9

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

Threaded View

  1. #1
    Registered User
    Join Date
    11-07-2014
    Location
    California
    MS-Off Ver
    2010
    Posts
    54

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

    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
    Last edited by khhoa; 02-24-2015 at 09:28 PM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help with Multiline textbox and removing a line from it
    By yoursamrit2000 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-09-2015, 12:57 AM
  2. Replies: 8
    Last Post: 07-14-2014, 03:07 AM
  3. [SOLVED] Concatenate If Blank - remove blank line if first cell is blank
    By ker9 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-27-2014, 02:14 PM
  4. Pass value and add line to multiline textbox
    By fredpox in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-18-2010, 06:02 AM
  5. How do I remove repeating line in Excell - Top line on each page..
    By keepon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-23-2005, 08:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1