Formatting Buttons

[Guest]

I am able to change the color and font of the text on a button, but do not know if it is possible to change to color or look of the button.

 

[Bob Phillips]

If you are using Forms buttons, no you can't. Control toolbox buttons yes,
forms no.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

I am able to change the color and font of the text on a button, but do not

know if it is possible to change to color or look of the button.

 

[Guest]

I was using the Forms Buttons. I tried using the Control Box Buttons, but I am unable to assign a macro
The colored buttons sure are more attractive.

 

[Bob Phillips]

No, you use the button's click event to trigger your code.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Peter T]

The colored buttons sure are more attractive.

If your button is to fire a macro you can use any Shape
and format every which way. Right click and "Assign macro".

On the Drawing toolbar look at Autoshapes / Basic Shapes
and one that looks like a double rectangle, this can look
like a button (maybe format the line to "No Line").

Regards,
Peter

-----Original Message-----
I was using the Forms Buttons. I tried using the Control

Box Buttons, but I am unable to assign a macro.

 

[Dave Peterson]

If you drop the button from the controlbox on worksheet, you can double click on
the button and you'll be taken into the VBE to see what runs when you click on
that button.

Just call your macro (in a general module???) from there.

Option Explicit
Private Sub CommandButton1_Click()
Call myOldMacro
End Sub

(There's a button on that controltoolbox toolbar that you may need to toggle
on/off when you're making changes--you'll see a "design mode" tooltip when you
let the cursor linger over it.)