I have a text box and cannot use the Enter key to seperate lines

  • Thread starter Thread starter Geechee
  • Start date Start date
whether it's a textbox in a userform or on the sheet, you have to
program it to do what you want it to. all by itself it doesn't do
anything. what do you want it to do when you hit "enter"?
susan
 
from a post in excel.programming:

To get the Enter key to take you to the next line in a
textbox (where MultiLine = True), set the EnterKeyBehavior
property to True.

maybe this is what you want.
susan
 
you have to toggle "design mode" - it's a toolbar button that has a
triangle, pencil & ruler on it. once that is pressed, you can right
click the toolbar & click on "properties".
find "multiline" and change that to true.

the design mode button is on the control toolbox toolbar - you can
find that toolbar (if you don't already have it visible) by right
clicking up in your toolbars and choosing "control toolbox".
:)
susan
 
I'm looking at the top of my spreadsheet and can't find the toolbar button
anywhere.... I know it's there somewhere but just frustrated that a simple
thing like working in a Text Box has been made so difficult.....

Thanks.
 
Back
Top