Check Boxes in Cells

T

Tony

I would like to have check boxes in cells to display any expression that
evaluates to True (checked) or False (unchecked).

And, I would like to change the cells' value to be "True" or "False" by
clicking the box - one in each cell.

I don't think this is the job for the check box control.

Can this be done?
 
J

J.E. McGimpsey

A checkbox from the Forms toolbar will do exactly this. In the
Format checkbox dialog, set the cell link to your target cell.
Clicking the checkbox will toggle the cell's value between True and
False. Entering 0 in the linked cell will clear the checkbox;
entering a non-zero value will put a check in it.
 
T

Tony

Thanks Bob, this works fine.

However I can't figure out how to make it work on the active cell.
For example if you click on a cell by mistake you have to move off it first
before toggling it back.

Any clues?

cheers
Tony
 
Top