| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkbox - Change color of label when clicked
Is there a way to change the background color of a checkbox label when it is
checked and change it back to white if it is un-checked? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Checkbox - Change color of label when clicked
Hi
Private Sub CheckBox1_Change() If CheckBox1.Value = True Then CheckBox1.BackColor = RGB(0, 255, 0) Else CheckBox1.BackColor = RGB(255, 255, 255) End If End Sub hth |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Checkbox - Change color of label when clicked
Thanks Keith! Works great.
"Keith74" wrote: Hi Private Sub CheckBox1_Change() If CheckBox1.Value = True Then CheckBox1.BackColor = RGB(0, 255, 0) Else CheckBox1.BackColor = RGB(255, 255, 255) End If End Sub hth |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checkbox to change background color, font color and remove/ add bo | Excel Discussion (Misc queries) | |||
| CheckBox to change cell color | New Users to Excel | |||
| Change Macro button color after clicked | Excel Discussion (Misc queries) | |||
| Change label border color at runtime | Excel Programming | |||
| how do I make checkbox color change when the value changes? | Excel Discussion (Misc queries) | |||
Linear Mode
