Auto-checking a checkbox based on cell contents.
 

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

Auto-checking a checkbox based on cell contents.
 

Hi Ramon
this would require VBA using an event procedure like worksheet_change

--
Regards
Frank Kabel
Frankfurt, Germany

"Ramon Cantu Jr." schrieb im Newsbeitrag
om...
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

Auto-checking a checkbox based on cell contents.
 

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.



"Ramon Cantu Jr." wrote:

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

--

Dave Peterson