Lenny,
Try something like the following:
Dim Ctrl As MSForms.Control
Dim N As Long
For Each Ctrl In UserForm1.Controls
If TypeOf Ctrl Is MSForms.CheckBox Then
N = N + 1
End If
Next Ctrl
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Lenny_821" wrote in
message ...
Hi All,
I've got a few CheckBoxes in a UserForm. How can I count the
CheckBoxes in VBA??
Please help:)
Lenny
--
Lenny_821
------------------------------------------------------------------------
Lenny_821's Profile:
http://www.excelforum.com/member.php...o&userid=15179
View this thread:
http://www.excelforum.com/showthread...hreadid=319438