+ Reply to Thread
Results 1 to 7 of 7

Help with Multiline textbox and removing a line from it

  1. #1
    Registered User
    Join Date
    09-27-2012
    Location
    Mumbai, IN
    MS-Off Ver
    Office 365
    Posts
    97

    Help with Multiline textbox and removing a line from it

    I have a multiline textbox. what i essentially want to do is whenever user enters # in any line of that multiline tb. i that line to be removed completely from text box. how can i do that. my text box is named tb1

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Help with Multiline textbox and removing a line from it

    May be try something like this....

    Please Login or Register  to view this content.

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,099

    Re: Help with Multiline textbox and removing a line from it

    Hi, ;) Sixtsense ;)

    from what I understand delete only the one line holding the string and not the whole string for the multiline. Maybe split the text at linebreak and compare each item in the array and add again after comparision.

    Ciao,
    Holger
    Last edited by HaHoBe; 01-06-2015 at 12:21 AM.
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Help with Multiline textbox and removing a line from it

    Quote Originally Posted by HaHoBe View Post
    from what I understand delete only the one line holding the string and not the whole string for the multiline.
    Hm... Yes you are right...

    Tricky Question

  5. #5
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Help with Multiline textbox and removing a line from it

    I used Holger Suggestion and made the necessary changes in my code

    Please check whether this solves your expectation

    Please Login or Register  to view this content.

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,145

    Re: Help with Multiline textbox and removing a line from it

    Assuming controls on the userform
    TextBox1 have original text
    TextBox2 entering number
    CommanButton1 to delete the line
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    09-27-2012
    Location
    Mumbai, IN
    MS-Off Ver
    Office 365
    Posts
    97

    Re: Help with Multiline textbox and removing a line from it

    Thank you Sir, this is exactly what i wanted. now would it be too much of me to ask, if it possible when that line vanishes i updates a new line in another textbox. For example if I have lets say rest in one line, test in anotherline. Is it possible to set a way that if ip place # in the line which has test in it , then the tb2 should say tb2.value+"Test Completed".....if user enters # in rest then tb2 should say rest completed.

+ 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. [SOLVED] Userform TextBox Multiline Declaration
    By calvinle in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-10-2014, 05:39 PM
  2. [SOLVED] TextBox Multiline: have <br> tag between lines
    By monak83 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-20-2012, 11:26 AM
  3. TextBox MultiLine and WordWrap
    By BillWilts in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-15-2010, 12:52 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. Scrollbars on a multiline textbox
    By johncassell in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-14-2008, 11:32 AM

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