Can you perform Math functions with ActiveX Checkbox controls?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 boxes


Regards,


Peo Sjoblom

http://nwexcelsolutions.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Resizing an activex checkbox control 2
How do I add a control check box to control other checkboxes? 1
math functions 1
IF checkbox is checked/unchecked, Cell.value = yes/no 3
Macro to clear checkboxes 5
IF Function Question 1
CheckBox Q 1
Access Combobox in Access Visible based on Checkbox 0

Back
Top