change the face color of an Excel command button

[Guest]

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.

 

[Chip Pearson]

You need to use the CommandButton object from the Controls
toolbar, not the Forms toolbar.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


message
news:[email protected]...

 

[Guest]

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.

Many thanks, Chip, but now it's difficult to simply attach a recorded macro?
Cheers
Chris Leah

 

[Earl Kiosterud]

Chris,

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.

Somehow your answer to Chip's post got posted as a reply to your original
post, not his reply.

 

[Guest]

Chris,

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.

Somehow your answer to Chip's post got posted as a reply to your original
post, not his reply.
--
Earl Kiosterud
www.smokeylake.com/
-------------------------------------------



Many thanks - problem solved

Chris Leah