Results 1 to 3 of 3

Thread: Is it possible to change the color of Microsoft Excel command button

  1. #1
    Join Date
    Jan 2012
    Posts
    66

    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.

  2. #2
    Join Date
    Jun 2011
    Posts
    492

    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)

  3. #3
    Join Date
    Jun 2011
    Posts
    804

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

Similar Threads

  1. Replies: 2
    Last Post: 01-02-2012, 01:08 PM
  2. How to change the line display color with the echo batch command?
    By coolthinking in forum Windows Server Help
    Replies: 5
    Last Post: 24-11-2011, 06:14 PM
  3. How to change the color of the start button in Linux mint
    By Ajacopa in forum Operating Systems
    Replies: 4
    Last Post: 19-01-2011, 07:05 PM
  4. How to change text color using 'IF" in Excel
    By Antrix in forum Windows Software
    Replies: 2
    Last Post: 26-06-2009, 07:02 PM
  5. Change IE Back Button Color
    By ubxoldier in forum Windows Software
    Replies: 3
    Last Post: 30-04-2009, 12:00 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •