Text box in excel user form
 

Hi All,

I have a text box on my user form where users input "Description" about them.

Rite now what is happening is, If a user inpus a data in that field the
input is like:

abcdefg higklafj aldkfjadfkl alkfjaldfkj aldfjaaldkfja ldsfjladfjfj

I want it to be like:

aldkfjdfa asdlfjaldksfj
akldfjajf aldkfj alfkjjllfj
aldkfjalfj adlffj adfljadfj
aldfjdfk asdlfjladlfj.

How can I design a text box such that it displays the text in this format?

Thanks in Advance.

Text box in excel user form
 

Set the TextBox's MultiLine and WordWrap properties to True.

You may also want to set the ScrollBars property to 2 (vertical scroll
bars) if your users are fond of entering a lot of text...


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113133