Thread: Checkbox
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ture Magnusson Ture Magnusson is offline
external usenet poster
 
Posts: 21
Default Checkbox

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/