Right click then checkbox and select format control, then put in a cell link
(might be best to link to a cell off the visible area like Z1 then use that
cell in the formula, the linked cell will display TRUE if checked using
default settings, like
=IF(Z1,"Do this","Do that")
or
=IF(Z1,"Do this","")
also if you want to count how many have been checked use
=COUNTIF(Z1:Z20,TRUE)
where you would put different checkboxes linked to different cells in Z1:Z20
Regards,
Peo Sjoblom
"danielle" wrote:
I'm creating a spreadsheet and want to add check boxes. Once i create the
check boxes from the forms menu, how do i place a formula or macro for these
boxes?
thanks for your help in advance
|