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