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

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Doh, made a mistake so time to edit:)

The font property gives the option to change size and font type.
 
Upvote 0
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. :)
 
Upvote 0

Forum statistics

Threads
1,214,400
Messages
6,119,288
Members
448,885
Latest member
LokiSonic

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