software

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?

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 boxesRegards,Peo Sjoblom

nwexcelsolutions.com

quot;ForTor69quot; wrote:

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