I have a userform. It is increasing in complexity with
various controls in it. It has:

1 Text Box
6 checkboxes
2 buttons


Is there a way to count the number of check boxes the form
has? I know that I can count the number of total controls
by :

NumberofControls = Userform1.Controls.Count

This gives me a value of 9 which includes the text box and
the two buttons. How do I isolate the checkboxes or any
other control of my liking.


Thanks