change the face color of an Excel command button

C

Chris Leah

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

Chris Leah

Chris Leah said:
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.
Click to expand...
Many thanks, Chip, but now it's difficult to simply attach a recorded macro?
Cheers
Chris Leah
 
E

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

Chris Leah

Earl Kiosterud said:
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
Click to expand...
Chris Leah
 
Top