Percentage of Checkboxes = True 1

[RP1America]

I have 33 activex checkboxes on an excel sheet. I would like to be able to calculate the percentage of how many of those are checked.

Thoughts?

 

[SkipVought]

hi,

Are each of these not linked to a cell on the sheet?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[RP1America]

They are not.

 

[SkipVought]

Then you'll have to loop thru the SHAPES on the sheet, determining which are CheckBoxes to 1) count existence and 2) count state of interest.

This might help: faq707-4594

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[RP1America]

Yikes! Not sure how that relates, because that went way over my head.

If the checkboxes were linked to cells, would there be an easier way to accomplish this?

 

[SkipVought]

Yes, just use the AverageIf() function over the range of linked cells

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

FYI, I rarely if ever place a control on multiple rows.

I would add ONE CheckBox control on the sheet and make its Visible property FALSE until the user select ONE CELL in the range intended for entry by the CheckBox. In that event, the Worksheet_SelectionChange event, 1) the control is POSITIONED IN THE CELL, using the TOP, LEFT, HEIGHT, & WIDTH properties, made Visible and then on that control's CHANGE event, the VALUE is placed in the cell that has the control's TOPLEFT property.

ONE CONTROL for MULTIPLE CELLS. ;-)

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]