Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I make checkbox color change when the value changes?
I am using a checkbox. I would like the color of the check box to change
when checked. Is that possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I make checkbox color change when the value changes?
If the checkbox is a control toolbox checkbox, use
Private Sub CheckBox1_Click() With Me.CheckBox1 If .Value Then .BackColor = RGB(255, 0, 0) Else .BackColor = RGB(255, 255, 255) End If End With End Sub -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Lynda" wrote in message ... I am using a checkbox. I would like the color of the check box to change when checked. Is that possible? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I make checkbox color change when the value changes?
Thank you!
"Bob Phillips" wrote: If the checkbox is a control toolbox checkbox, use Private Sub CheckBox1_Click() With Me.CheckBox1 If .Value Then .BackColor = RGB(255, 0, 0) Else .BackColor = RGB(255, 255, 255) End If End With End Sub -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Lynda" wrote in message ... I am using a checkbox. I would like the color of the check box to change when checked. Is that possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a 3-dimensional plot in Excel? | Charts and Charting in Excel | |||
Can I make formulas more flexible? | Excel Discussion (Misc queries) | |||
How do I make each row add up seperatly? Please make it easy... | New Users to Excel | |||
make hidden window or workbook visible without specify the name | Excel Worksheet Functions | |||
make cell contents equal to null value - not blank, but empty | Excel Worksheet Functions |