Tracking Check Boxes

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

Guest

I have designed a new workbook in whick I have several check boxes in a
common column. As I check these boxes I would like to keep track of the total
number of boxes that I have checked off in each column. Is there a function
that will allow me to do this? Something similar to the way that the SUM
function works.
Using check boxes allows me to do less typing.
 
You can link the checkboxes to a cell. This linked cell will return TRUE
when the ckbx is checked and FALSE when the ckbx is unchecked. Then you can
use a formula to count the number of TRUE's:

Ckbx's in column A, A1:A10. Linked cells B1:B10.

=COUNTIF(B1:B10,TRUE)

You can hide the linked cells if you don't want to see the TRUE or FALSE.
Hide the column or set the font color to be the same as the background
color. You can also link the ckbx to the cell it's "in" and not need a
separate column.

How you link the ckbx to a cell depends on which type od ckbx you're using.
If it's from the Forms toolbar, right click the ckbx and select Format
Control>Control tab. If it's from the Control Toolbox, open the Control
toolbox, turn on Design Mode, right click the ckbx, select Properties and
look for Linkedcell. Exit Design Mode.

Biff
 
Back
Top