Change the color of an Excel Macro button?
 

Can I change the color of Macro Buttons that Excel makes?

Change the color of an Excel Macro button?
 

If the button is from the control toolbox toolbar, then click on the design mode
icon (on that same toolbar), rightclick on the commandbutton and select
properties. Look for Backcolor.

If the button is from the Forms toolbar, you can change the font--but not the
backcolor.

JT wrote:

Can I change the color of Macro Buttons that Excel makes?

--

Dave Peterson

Change the color of an Excel Macro button?
 

My next question is can I assign a macro recorded in MS Visual Basic to a
button inserted from the Contron Box Toolbar instead of the Forms Toolbar?

Thanks For your Response.
Jeff

"Dave Peterson" wrote:

If the button is from the control toolbox toolbar, then click on the design mode
icon (on that same toolbar), rightclick on the commandbutton and select
properties. Look for Backcolor.

If the button is from the Forms toolbar, you can change the font--but not the
backcolor.

JT wrote:

Can I change the color of Macro Buttons that Excel makes?

--

Dave Peterson

Change the color of an Excel Macro button?
 

Two things.

You don't assign macros to control toolbox buttons, they have a click event
associated with them (which of course can call a macro).

On the question, if you mean can use VB code in a VBA macro, in principle
yes, although you may need to make small changes. If you mean call the
procedure in a VB executable, that is more difficult. You could wrap it all
in a DLL, link that DLL to your VBA project, and call it from there.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JT" wrote in message
...
My next question is can I assign a macro recorded in MS Visual Basic to a
button inserted from the Contron Box Toolbar instead of the Forms Toolbar?

Thanks For your Response.
Jeff

"Dave Peterson" wrote:

If the button is from the control toolbox toolbar, then click on the
design mode
icon (on that same toolbar), rightclick on the commandbutton and select
properties. Look for Backcolor.

If the button is from the Forms toolbar, you can change the font--but
not the
backcolor.

JT wrote:

Can I change the color of Macro Buttons that Excel makes?

--

Dave Peterson

Change the color of an Excel Macro button?
 

Looks like this is getting way over my head now. I guess I don't need a
different color on my buttons after all !! I do appreciate everyone helping
me with this. Thanks for the short description on what the difference is
between the control toolbox and the form buttons.

"Bob Phillips" wrote:

Two things.

You don't assign macros to control toolbox buttons, they have a click event
associated with them (which of course can call a macro).

On the question, if you mean can use VB code in a VBA macro, in principle
yes, although you may need to make small changes. If you mean call the
procedure in a VB executable, that is more difficult. You could wrap it all
in a DLL, link that DLL to your VBA project, and call it from there.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JT" wrote in message
...
My next question is can I assign a macro recorded in MS Visual Basic to a
button inserted from the Contron Box Toolbar instead of the Forms Toolbar?

Thanks For your Response.
Jeff

"Dave Peterson" wrote:

If the button is from the control toolbox toolbar, then click on the
design mode
icon (on that same toolbar), rightclick on the commandbutton and select
properties. Look for Backcolor.

If the button is from the Forms toolbar, you can change the font--but
not the
backcolor.

JT wrote:

Can I change the color of Macro Buttons that Excel makes?

--

Dave Peterson