View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default userform textbox: hit enter to start writing in a new line

Hi Sam,

Set Multiline property to True and
Set EnterKeyBehaviour property to True

--
Regards,

OssieMac


"sam" wrote:

Hi All,

I have a text box in a userform where users enter big sentences. This text
box is designed a little bigger as compared to other text boxes.
What I want is:
If users start inputing the text and they want to write something in a new
line, they can hit enter and start from a new line, Something like microsoft
word, once we hit enter we get on a new line.

I hope I made it clear

Thanks in advance