How to Press "enter' for a new line in a textbox?

[Patriot2879]

hi,
I have a testbox1 in excel where after typing data in the text box i want to be able if required to press enter and start a new line in the textbox1, i am using the code below but i get an error please can you help me? thank you in advance.

Private Sub TextBox1_Change()
    If KeyCode = vbKeyReturn Then
        Me.NewLine
    End If
End Sub

 

[ranman256]

ctl-enter on the keyboard,
in code: vbCrLf

 

[Patriot2879]

Thnak you for your help, all sorted now many thanks code works great

 

[Norie]

If you set the MultiLine and EnterKeyBehavior properties of the textbox to True all you need to do is press Enter.

 

[Patriot2879]

just tried that thank you thats great i tried this earlier but only changed the multiline to True and not the other, that is great thank you

 

[Norie]

I always forget to change both too.

 

[Patriot2879]

Thats one to remember i am pretty new to this , still learning but enjoying it at the same time