Ho to edit text in a custom button

  • Thread starter Thread starter donwb
  • Start date Start date
D

donwb

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
 
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
 
Many thanks Gord.
That did it.
donwb

Gord Dibben said:
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
Click to expand...
 
Assuming a button from the Control Toolbox.
In design mode, right-click on the edge of button and "Properties"

Make sure "WordWrap" is True
Click to expand...

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.
 
Back
Top