Text box in excel user form

S

sam

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.
 
J

jamescox

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...
 
Top