A
ABYPFCS
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.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
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)
forms no.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
know if it is possible to change to color or look of the button.ABYPFCS said:I am able to change the color and font of the text on a button, but do not
A
Al Bailey
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.
The colored buttons sure are more attractive.
B
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)
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
P
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
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
Box Buttons, but I am unable to assign a macro.-----Original Message-----
I was using the Forms Buttons. I tried using the Control
D
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.)
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.)