Home |
Search |
Today's Posts |
#1
|
|||
|
|||
checkbox and macros
I am trying to make a checkbox work as an on off switch. I would like it to
change the background color of a group of cells. Is this possible? |
#2
|
|||
|
|||
Hi Tdebb8594
If you use a checkbox from the control toolbox you can use this code in the Click event Private Sub CheckBox1_Click() If Me.CheckBox1.Value = True Then Range("A1:A10").Interior.Color = vbRed Else Range("A1:A10").Interior.Color = xlAutomatic End If End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Tdebb8594" wrote in message ... I am trying to make a checkbox work as an on off switch. I would like it to change the background color of a group of cells. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|