Cadbury,
Here is an approach where you don't need VBA for this.
You can use a linked cell in combination with conditional
formatting.
1. Create the checkbox
2. If the checkbox is from the "Forms" toolbar:
- Right-Click the checkbox and select "Format Control"
- Select the Control tab
- Set cell link to A1
- Click OK
If the checkbox is fron the "Control Toolbox" toolbar:
- Right-Click the checkbox and select "Properties"
- Set the cell link property to A1
- Close the properties window
- Click the "Exit Design Mode" toolbar button
3. Select the cell you want to color
5. Format - Conditional Formatting
Formula is... =A1=TRUE
Click Format, set Red color on Patterns tab
6. Click OK, twice
--
Ture Magnusson
Microsoft MVP - Excel
Karlstad, Sweden
"cadbury" wrote in message
...
I need to highlight (color-fill) a cell when a checkbox is clicked and
then be able to unclick and have the cell have no-fill.
anyone know how to do this?
Cadbury
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/