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