Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



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

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 21-01-2012
Member
 
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.

Reply With Quote
  #2  
Old 21-01-2012
Member
 
Join Date: Jun 2011
Posts: 486
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)
Reply With Quote
  #3  
Old 21-01-2012
Member
 
Join Date: Jun 2011
Posts: 798
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".
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Is it possible to change the color of Microsoft Excel command button"
Thread Thread Starter Forum Replies Last Post
Not able to change font color in some cells of Microsoft Excel Garsen's MS Office Support 2 01-02-2012 01:08 PM
How to change the line display color with the echo batch command? coolthinking Windows Server Help 5 24-11-2011 06:14 PM
How to change the color of the start button in Linux mint Ajacopa Operating Systems 4 19-01-2011 07:05 PM
How to change text color using 'IF" in Excel Antrix Windows Software 2 26-06-2009 07:02 PM
Change IE Back Button Color ubxoldier Windows Software 3 30-04-2009 12:00 AM


All times are GMT +5.5. The time now is 05:28 AM.