change the face color of an 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.

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


"Chris Leah" <Chris Leah@discussions.microsoft.com> wrote in
message
news:70ABA2EE-7A9B-4469-9AFC-31CCBB864F34@microsoft.com...
> 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.
>

"Chris Leah" wrote:

> 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

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/
-------------------------------------------

"Chris Leah" <ChrisLeah@discussions.microsoft.com> wrote in message
news:8C7CD0B9-4C20-4B33-AEE7-2FBC8DD51F38@microsoft.com...
>
>
> "Chris Leah" wrote:
>
>> 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" wrote:

> 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/
> -------------------------------------------
>
> "Chris Leah" <ChrisLeah@discussions.microsoft.com> wrote in message
> news:8C7CD0B9-4C20-4B33-AEE7-2FBC8DD51F38@microsoft.com...
> >
> >
> > "Chris Leah" wrote:
> >
> >> 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 - problem solved
Chris Leah