+ Reply to Thread
Results 1 to 4 of 4

Excel 2010 Userform Textbox Word Wrap

  1. #1
    Valued Forum Contributor jwright650's Avatar
    Join Date
    12-10-2010
    Location
    Va, USA
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    606

    Excel 2010 Userform Textbox Word Wrap

    Hi Folks,
    I've been trying to get the text in my VBA Userform textboxes to wrap onto the next line when it runs into the border of the box.
    How do you set it up so that it does this. I've tried the properties window and set the word wrap to true but the text still stays on one line and goes out of sight.
    Any help is appreciated.









    EDIT: Thanks Marvin, it worked perfectly!
    Last edited by jwright650; 12-27-2010 at 11:18 AM.
    Life is like a roll of toilet paper. The closer it gets to the end, the faster it goes.
    John Wright

  2. #2
    Valued Forum Contributor jwright650's Avatar
    Join Date
    12-10-2010
    Location
    Va, USA
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    606

    Re: Excel 2010 Userform Textbox Word Wrap

    I just realized that I posted in the Misc forum, if this is not the appropriate forum hopefully an admin or mod will move to the correct location for me....or should I delete it and start it over somewhere else? Still trying to figure out the forum here, so be gentle.

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Excel 2010 Userform Textbox Word Wrap

    Hi jwright650,

    You need to set the property of MultiLine to true also for the TextBox.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Valued Forum Contributor jwright650's Avatar
    Join Date
    12-10-2010
    Location
    Va, USA
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    606

    Re: Excel 2010 Userform Textbox Word Wrap

    Thanks Marvin...I'll give it a try. Thanks for the quick help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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