Writing VBA code to read checkboxes

Hi,

I an a novice, so please bare with me. I have added form control checkboxes to my spreadsheet (Sheet1). Then I would like to use a ActiveX Command Button that when pressed will return to me how many checkboxes have been checked. Not sure where to begin. Can someone please advise?

Thanks,

swb1

Swb1

I'm not in front of my computer at present but each check box is linked to a cell and will show as either true or false.the logic I'd use is to count the number of cells that are 'true'. Do you have an example of your spreadsheet?

Yes, I am attaching it now. Thanks for replying!

So none of the checkboxes are linked to cells. You could probably write code to check the status of each check box but with the number you've got I suspect this will be a lot of code with if statements. Someone else might know. As stated earlier I think you could avoid all this by linking the check boxes to cells and counting the number of 'True'

Yes, I like the X in the column idea and then counting. Thanks! Will try that.