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.
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.
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)
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".
Bookmarks