Forum Discussion
Shape Format is not working with Control Button
It's not you. The only aspect of a Form Controls command button that you can format is the caption and its formatting. You cannot specify the shape, the fill color, etc.
As an alternative, insert a shape such as a rounded rectangle or whatever you prefer on the sheet. You can apply shape styles etc., and you can assign a macro to the shape so that it will act like a button.
It's not you. The only aspect of a Form Controls command button that you can format is the caption and its formatting. You cannot specify the shape, the fill color, etc.
As an alternative, insert a shape such as a rounded rectangle or whatever you prefer on the sheet. You can apply shape styles etc., and you can assign a macro to the shape so that it will act like a button.
HansVogelaar Thank you for the alternative tips!
- Rather oddly, you can set a fill colour for an option button. I don't know when that came about or why it received special treatment.
The same holds for a check box from Form Controls...
