Need to Count number of Check Boxes checked on a userform

Hi,
there are two ways to do this.
First - use custom class and change the counter every time when checkbox is checked/unchecked. It's more complicated and maybe a bit of overkill depending on what your needs are.

Second option - more simple. loop trough controls on the form when some button (e.g.OK button) is clicked, count the number of checked checkboxes and use it in the code after that
here is macro that will do the second option

Please Login or Register  to view this content.

Is this something you can work with?

Please Login or Register  to view this content.

Oops! Nevermind...You have checkboxes on a UserForm...not worksheet.

Hello UMBiii,

Ron had the right idea. For a VBA UserForm the loop would look like this.

Please Login or Register  to view this content.