ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Textbox in user form (https://www.excelbanter.com/excel-programming/383532-textbox-user-form.html)

Curt

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

Chip Pearson

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




Christmas May[_2_]

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






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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com