I want 'Enter' to be a line break in a text-box

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

I want to be able to type text into a multi-line text-box on a form,
and when I hit the Enter key, I want it to insert a line-break (hard
or soft) or paragraph break so that I can then type on the next line.

At the moment, when I press Enter, it moves to the next control on the
form.

(When I'm not in the text-box,I'm happy for Enter to just do what it
normally does.)

Is this possible?

M
 
Set the MultiLine property to True and set the EnterKeyBehavior
property to True. You can do this manually in the designer's
Properties window or with code when the form loads:

Private Sub UserForm_Initialize()
With Me.TextBox1
.MultiLine = True
.EnterKeyBehavior = True
End With
End Sub

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Want Enter to put CR in Textbox (not just CTRL-Enter) 7
userform textbox: hit enter to start writing in a new line 4
Extracting a number from a multiline-entry 9
Line break in cell 2
mysteriously enters into break mode 5
Carriage return in a Text box 2
Text boxes in forms 1
Paragraph Break: change DEFAULT to "Shift+Enter" 5

Back
Top