ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Carriage return in a Text box (https://www.excelbanter.com/excel-programming/377867-carriage-return-text-box.html)

Riddler

Carriage return in a Text box
 
I have a text box on a user form that I want the user to be able to hit
enter and have it move to the next line to enter more text. When I hit
enter it moves to the next tab order item. I turned that off but enter
just does nothing. How can I use the enter key to input multiple lines
of text into a text box?

Thanks
Scott


Bob Umlas

Carriage return in a Text box
 
2 properties of the text box must be turned on:
EnterKeyBehavior should be set to True, and
MultiLine should be set to True/
(of course, in addition to WordWrap True)
Bob Umlas

"Riddler" wrote in message
oups.com...
I have a text box on a user form that I want the user to be able to hit
enter and have it move to the next line to enter more text. When I hit
enter it moves to the next tab order item. I turned that off but enter
just does nothing. How can I use the enter key to input multiple lines
of text into a text box?

Thanks
Scott




Riddler

Carriage return in a Text box
 
That did the trick!! For some reason I did not have the
EnterKeyBehavior set to true.
Thanks a bunch.....

Scott



All times are GMT +1. The time now is 04:53 PM.

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