evaluate check box
Posted by K Miles on January 19, 2002 2:46 PM
How do I determine the value of a check box (checked/not) in an 'IF' statement. In other words, do whatever to this cell IF that checkbox is checked.
Posted by Ivan F Moala on January 19, 2002 4:55 PM
If the checkbox is from the forms toolbar then
the checkbox has a format control called
[cell link]; Link the checkbox to a cell
say A1...checking the checkbox yields True in
A1...unchecking yields False.
If checkbox is from the ControlToolbox then
The checkbox has a property > Linktocell
Link it here to say A2......same as above
in terms of the result.
Its just a matter of now linking your formula
to the linked cell.
HTH
Ivan
