View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Userform Question

If the textbox is from the control toolbox toolbar, then you need to set the
property for EnterKeyBehavior to True

from help for EnterKeyBehavior

True Pressing ENTER creates a new line.
False Pressing ENTER moves the focus to the next object in the tab
order (default).


also, you might want to set MultiLine property to True as well. (although
this is the default)

True The text is displayed across multiple lines (default).
False The text is not displayed across multiple lines.


and possibly the wordwrap property to true. (again, the default)

True The text wraps (default).
False The text does not wrap.


--
Regards,
Tom Ogilvy



"Josh" wrote in message
...
I am not sure what to call it. To try and explain better, I want a large

text box like box where the user can write notes on what they are doing. I
have tried having just a large text box but the return key doesn't go to the
next line.

Any suggestions on how to accomplish this?

Josh