MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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