Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 74
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 923
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default 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



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
WordWrap a TextBox on a UserForm dcornett63 Excel Discussion (Misc queries) 2 April 22nd 10 09:35 PM
Textbox in userform Harald Staff Excel Programming 0 September 8th 04 11:51 AM
WordWrap in textbox Jason Morin[_3_] Excel Programming 3 April 15th 04 02:11 PM
Textbox in userform shaharul[_6_] Excel Programming 3 April 15th 04 12:54 PM
UserForm TextBox to ActiveSheet TextBox over 256 characters Dan E[_2_] Excel Programming 1 July 28th 03 07:36 PM


All times are GMT +1. The time now is 10:43 PM.

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"