CommandButton caption size?

backup69

Active Member
Joined
Jan 20, 2004
Messages
271
Hi

How i can resize frame around the button caption or increase caption size so that the text wont dissappear behind the frame if i minimize size button.
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

parry

MrExcel MVP
Joined
Aug 20, 2002
Messages
3,355
Doh, made a mistake so time to edit:)

The font property gives the option to change size and font type.
 

parry

MrExcel MVP
Joined
Aug 20, 2002
Messages
3,355
Im not sure what you mean 'so that the text wont dissappear behind the frame if I minimize size button'.

For all the caption text to fit in the CommandButton you have to resize the button. How much you have to do that depends upon the font type used (Arial etc) and what font size you use. For example, Arial Narrow is a thinner text type than Arial and you can also change the size down from the default of 10 to say 8 or 6 etc.

There is also the ability to wrap the text so its not too wide (WordWrap = True) plus the button can be autosized to the minimum size needed that will fit all the caption text (Autosize = True).

You also have the ability to insert a picture into a button so you could create a picture and overlay text within the picture then add the picture to the button. You would also need to remove the text in the caption as this will still appear in the button.

Thats about exhausted all the sizing options im aware of. :)
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,102
Messages
5,768,102
Members
425,454
Latest member
khoro

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top