Counting checkboxes
 

How do you count the number of Checkboxes in a Userform?

Counting checkboxes
 

Dim ctrl as Control
Dim icnt as long
icnt = 0
for each ctrl in Userform1.Controls
if typeof ctrl is MSForms.CheckBox then
icnt = icnt + 1
end if
Next
msgbox "there are " & icnt & " checkboxes"

--
Regards,
Tom Ogilvy


"Shamsul" wrote in message
...
How do you count the number of Checkboxes in a Userform?