Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 469
Default Textbox in user form

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 63
Default Textbox in user form

Chip,

Please email me.

Thanks in advance,

Christmas May



"Chip Pearson" wrote:

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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Textbox on user form in Excel VBA Gimp Excel Programming 4 January 16th 07 05:34 PM
textbox on user form Mike Excel Programming 3 December 2nd 05 04:43 PM
User Form in VB = TextBox Kel Excel Discussion (Misc queries) 1 August 11th 05 12:26 AM
Textbox trouble on a user form Oreg[_3_] Excel Programming 7 May 27th 04 12:36 AM
User Form textbox formatting Neal[_2_] Excel Programming 0 August 20th 03 08:14 PM


All times are GMT +1. The time now is 07:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"