+ Reply to Thread
Results 1 to 9 of 9

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

  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

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

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

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

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

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

    Bump no response

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

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

    Bump no response

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

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

    Bump no response

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    17,097

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

    How about 2 in 1
    Please Login or Register  to view this content.
    Last edited by jindon; 02-24-2015 at 06:27 PM.

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

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

    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

  8. #8
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    17,097

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

    Then try change to
    Please Login or Register  to view this content.

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

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

    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.

+ Reply to Thread

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