Ho to edit text in a custom button
 

Excel 2003, Win XP
I have created a custom command button on a worksheet,
with associated code.
I have annotated the button with suitable text.
How do I split the text, so that it occupies 2 lines (or even 3)
instead of just 1.
I have tried making the button taller, but it makes no difference.
donwb

Ho to edit text in a custom button
 

Assuming a button from the Control Toolbox.

In design mode, right-click on the edge of button and "Properties"

Make sure "WordWrap" is True

Assuming button is from Forms Toolbar, simply hit ENTER key after each line
you want.


Gord Dibben MS Excel MVP


On Sun, 20 Sep 2009 18:43:42 +0100, "donwb" wrote:

Excel 2003, Win XP
I have created a custom command button on a worksheet,
with associated code.
I have annotated the button with suitable text.
How do I split the text, so that it occupies 2 lines (or even 3)
instead of just 1.
I have tried making the button taller, but it makes no difference.
donwb

Ho to edit text in a custom button
 

Many thanks Gord.
That did it.
donwb

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Assuming a button from the Control Toolbox.

In design mode, right-click on the edge of button and "Properties"

Make sure "WordWrap" is True

Assuming button is from Forms Toolbar, simply hit ENTER key after each
line
you want.


Gord Dibben MS Excel MVP


On Sun, 20 Sep 2009 18:43:42 +0100, "donwb"
wrote:

Excel 2003, Win XP
I have created a custom command button on a worksheet,
with associated code.
I have annotated the button with suitable text.
How do I split the text, so that it occupies 2 lines (or even 3)
instead of just 1.
I have tried making the button taller, but it makes no difference.
donwb

Ho to edit text in a custom button
 

Assuming a button from the Control Toolbox.

In design mode, right-click on the edge of button and "Properties"

Make sure "WordWrap" is True

Just to follow up, you can force the "new lines" on a Control Toolbox
CommandButton (instead of having to resize the width of the button in order
to force word wrapping) as follows...

While in Design Mode, select the CommandButton, right click it and select
CommandButton Object/Edit from the popup menu that appears. This will put
you inside the text of the CommandButton... place the cursor where you want
a new line to appear and key in Ctrl+Enter.

--
Rick (MVP - Excel)