You must set the MultiLine property to True.
With Me.TextBox1
.MultiLine = True
.WordWrap = True
.Text = String$(260, "A")
End With
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
"Curt" wrote in message
...
trying to get text to appear in text box to give direction size needs text
to
wrap wrap = true doesn't wrap? setting in properties
not sure where to go next
Thanks