ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using the Return Key without exiting Textbox (https://www.excelbanter.com/excel-programming/383274-using-return-key-without-exiting-textbox.html)

Corey

Using the Return Key without exiting Textbox
 
I am setting up a Textbox with WordWrap=True.
I want to be able to go to the next line to enter MORE text, but i get taken to the next Textbox.
Is there a way to do this?
I noticed that although wordwrap=true, i still get 1 line of text across the top line???

Corey....



Greg Wilson

Using the Return Key without exiting Textbox
 
Assuming you mean a text box in a userform, set Multiline to True and
EnterKeyBehaviour to True. I don't have the behaviour you describe for
worksheet based text boxes so I have assumed a uf.

Regards,
Greg


"Corey" wrote:

I am setting up a Textbox with WordWrap=True.
I want to be able to go to the next line to enter MORE text, but i get taken to the next Textbox.
Is there a way to do this?
I noticed that although wordwrap=true, i still get 1 line of text across the top line???

Corey....





All times are GMT +1. The time now is 07:15 PM.

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