Checkbox from control toolbar macro
Yes, you just need to know the name of the control. For this example, assume
the name is CheckBox1 (the default name Excel will give to the first check
box)....
Sub Test()
With CheckBox1
.BackColor = vbRed
.ForeColor = vbWhite
.Caption = "HELLO"
End With
End Sub
Run the above macro and the check box will read HELLO in white letters on a
red background. You can modify almost all of the controls (any control you
place, not just a check box) using the structure above.
Rick
"Patrick Bateman" wrote in
message ...
Hi
is it possible to create a macro to change the colour and caption
properties
of a checkbox inserted friom the control toolbar?
thankyou for your help
Patrick
|