How to Count Check Boxes and count the total number of boxes checked

**t04904** · 07-09-2013, 01:53 PM

My goal is to count the number of Check Boxes on each worksheet and the total number of checked checkboxes on each worksheet.
I am probably making this too complicated and can use the help.

Thanks

Please Login or Register  to view this content.

**tigeravatar** · 07-09-2013, 02:04 PM

t04904,

Welcome to the forum! In the future, please wrap your code in code tags (link in my sig).
As for your question, I would do it like this:

Please Login or Register  to view this content.

**t04904** · 07-12-2013, 11:16 AM

You are awesome! The code you wrote got me through the main issues I had. Working on some smaller points now. I understand you may work with this every day, but you really helped our organization. We are a volunteer organization that helps local kids particpate in soccer. This will greatly reduce our time registering the kids.

**tigeravatar** · 07-12-2013, 11:45 AM

You're very welcome

If that takes care of your need, please mark this thread as solved.
How to mark a thread Solved
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
Go to the first post
Click edit
Click Go Advanced
Just below the word "Title" you will see a dropdown with the words "No prefix"
Change to "Solved"
Click Save