ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   WordWrap in TextBox on a UserForm (https://www.excelbanter.com/excel-programming/373093-wordwrap-textbox-userform.html)

Noemi

WordWrap in TextBox on a UserForm
 
Hi
I have a textbox on a userform which in the properties has seleted WordWrap
as True however when you run the userform and a user keycs into the box the
text doesn't wrap.

Any idea's as to how to get the word to wrap and go to the next line so the
whole line is shown in the text box.

Thanks
Noemi

Nigel

WordWrap in TextBox on a UserForm
 
You also need to set the property MultiLine True as well.


--
Cheers
Nigel



"Noemi" wrote in message
...
Hi
I have a textbox on a userform which in the properties has seleted
WordWrap
as True however when you run the userform and a user keycs into the box
the
text doesn't wrap.

Any idea's as to how to get the word to wrap and go to the next line so
the
whole line is shown in the text box.

Thanks
Noemi




NickHK

WordWrap in TextBox on a UserForm
 
Noemi,
You have to set .MultiLine=True.

NickHK

"Noemi" wrote in message
...
Hi
I have a textbox on a userform which in the properties has seleted

WordWrap
as True however when you run the userform and a user keycs into the box

the
text doesn't wrap.

Any idea's as to how to get the word to wrap and go to the next line so

the
whole line is shown in the text box.

Thanks
Noemi





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

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