Auto-checking a checkbox based on cell contents.

R

Ramon Cantu Jr.

Is it possible to set or "check" a checkbox in real time, based on the
contents of a cell?

I know the cell link field can tie a cell to a check box, but (if I
understand it right) it's a one way link (meaning the cell reacts to
the check box).

Any help would be appreciated.

Thanks,

Ramon
 
D

Dave Peterson

If you link a cell to the checkbox (either from the Forms toolbar or the control
toolbox toolbar), then you can change that cell (true/false or 1/0) and the
checkbox will update.

But you can't have a formula in that linked cell if you're going to click on the
checkbox. It'll be overwritten.
 
Top