Can you perform Math functions with ActiveX Checkbox controls?
 

Is it possible to use a series of ActiveX controls (Checkboxes) and then do a
math function, such as COUNTIF to count the number of check boxes that are
checked (true)? What should be used to determine the state of the checkbox
and what would the proper syntax be?

Can you perform Math functions with ActiveX Checkbox controls?
 

Yes, you need to link the checkboxes to cells in a contiguous range, if you
right click a check box in design mode and select properties you can link it
to a cell, preferably you would link it to a range in a hidden column/row or
somewhere off view then just use

=COUNTIF(Range,TRUE)

where Range is the range you linked them to, it will return the number of
checked check boxes


Regards,


Peo Sjoblom

http://nwexcelsolutions.com

"ForTor69" wrote:

Is it possible to use a series of ActiveX controls (Checkboxes) and then do a
math function, such as COUNTIF to count the number of check boxes that are
checked (true)? What should be used to determine the state of the checkbox
and what would the proper syntax be?