PDA

View Full Version : Solved: How do you make text wrap in a textbox?



Pete634
05-24-2007, 04:49 PM
This is probably very simple, but so am I!

I have a textbox on a userform for users to enter notes into. When "lengthy" information is entered into the textbox the text is appearing on one line and stretching outside the box.:banghead:

I want it to drop to the below so it all appears in the box (with a vertical scroll bar if necessary).

Please put me out of my misery - how do I make it do this?

A VBA Newbie !!

lucas
05-24-2007, 05:24 PM
In the properties for the textbox make sure wordwrap and multiline are true....

Carl A
05-24-2007, 05:26 PM
Select the textbox and in properties set Multiline = True

Carl A
05-24-2007, 05:28 PM
:wot Opps Sorry Lucas must have been posting at same time

lucas
05-24-2007, 05:36 PM
The more the merrier Carl....no worries.:thumb

Pete634
05-24-2007, 05:45 PM
Thanks all. Thats the only one I didn't try!