I have check boxes that I would like to see change color when checked. Help
please for a novice

Hi,

Here is the basic idea, you will need code, and you should attach it to a
Control Toolbox checkbox:

Private Sub CheckBox1_Click()
Me.CheckBox1.BackColor = RGB(0, 128, 64)
End Sub


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"wimiko" wrote:

I have check boxes that I would like to see change color when checked. Help
please for a novice

Hi,

There is another way using conditional formatting. Suppose youwant the
checkbox red when unchecked and green when checked.
Create a checkbox from the Forms toolbar. Format control it with a cell link
of the cell you are going to position it in. Apply a red fill and red text to
that cell.
Drag your checkbox onto the cell, increase the cells height and width
slightly to fit, and make it snap to the cells borders by using the snap to
grid feature on the Drawing toolbar.
Then, using the arrow keys, move to the cell and apply conditional
formatting such that Cell value is equal to TRUE, and format the fill pattern
and text to be green.

Now the checkbox will switch between red and green if you check it.

Dave


"wimiko" wrote:

I have check boxes that I would like to see change color when checked. Help
please for a novice