looping through all checkbox's in a userform
 

Hi,

I have 35 checkboxes in my userform.

For each checkbox that is true I will do 'x'.

Anyone know the syntax to loop through all the checkboxes?

Thanks,
Robin



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

looping through all checkbox's in a userform
 

Hi Robin:

Dim ctl As Control
For Each ctl In UserForm1.Controls
If TypeOf ctl Is MSForms.CheckBox Then
If ctl Then
'your code here
End If
End If
Next

Regards,

Vasant.

"strataguru" wrote in message
...
Hi,

I have 35 checkboxes in my userform.

For each checkbox that is true I will do 'x'.

Anyone know the syntax to loop through all the checkboxes?

Thanks,
Robin



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/