Use formula in sheet to see activity of checkbox

[blacktour]

Is it possible to have an IF formula within a cell check to see if a Control Toolbox Checkbox is activated?

I realize you can use VBA for this or just use a cell with an "X" I was just curious if this is possible.

Thanks,
Mike

 

[Jonmo1]

This functionality is built into the checkbox.

In design mode, right click the checkbox - properties.
find the property "linked cell"

enter a cell reference like A1 for example...

A1 will now reflect TRUE/FALSE when the checkbox is Checked/Unchecked (respectively)