Is it possible to change the color of Microsoft Excel command button
How can I change the face color of a command button in Excel 2003 (View-Toolbars-Forms)? Changing font color is easy, but I don't know enough about VBA to change the button color.
Re: Is it possible to change the color of Microsoft Excel command button
You need to use the CommandButton object from the Controls toolbar, not the Forms toolbar. Double-click the command button while in Design Mode. It'll take you to the module for that button. Put your code in the CommandButton1_Click() sub.
For help refer to the following : Add a command button (ActiveX Control)
Re: Is it possible to change the color of Microsoft Excel command button
There are two types of "buttons" in excel. Buttons such as "form", where it is not possible to change the color of the button, created via the toolbox "form". The Button type "control" found in the userform, for which it is possible to change the color (among others), created via the toolbox "control".