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

[Geechee]

In a Text Box in Excel 2007, when I press the "Enter" key it does not work????

 

[Susan]

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

 

[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

 

[Geechee]

How do I get to place where I select "True"

Thanks.

 

[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

 

[Geechee]

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.

 

[Susan]

oh yeah, you said you have excel 2007. i don't know where the
toolbars are in 2007..........

http://groups.google.com/group/micr...control+toolbox+toolbar+2007#5d384fe09eb88d80

try this thread.
susan