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.
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 !!
In the properties for the textbox make sure wordwrap and multiline are true....
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Select the textbox and in properties set Multiline = True
"Intellectual passion occurs at the intersection of fact and implication."
SGB
Opps Sorry Lucas must have been posting at same time
"Intellectual passion occurs at the intersection of fact and implication."
SGB
The more the merrier Carl....no worries.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Thanks all. Thats the only one I didn't try!
Posting Permissions
Reply With Quote
