View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Textbox in user form

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