Tallying of check-box responses without linked cells.

[henryBukowski]

Hi folks,

I know that for every check-box, you can set-up a linked cell. To count the number of boxes ticked, you could simply do a countif of 'TRUE' values...

But what if you have thousands of check-boxes, and don't wish to set these references up individually - after all, they'd need to be assigned to their own cell! Can a single cell 'stack' the number of 'true' responses linked to it? I'm guessing not..

Could I perhaps instead use a macro to count, in a specified range, e.g checkbox1 - checkbox 10, the number assigned the 'TRUE' property?

I'd then output that value to cell, along the lines of Cells(2,3).Value = Count (Having set up the count variable to be the number of 'True' responses.)

Many thanks in advance for any advice offered.

[Solus Rankin]

To loop through them to count 'true' I believe they have to be activeX checkboxes instead of the form controls (which it sounds like you have).