Hi all,

This is my first post in this forum. Please apologize whatever I am posting doesn't make sense.

I have learnt VBA self and my knowledge on VBA is basic.

I was trying to loop checkboxes in the userform but didn't understood how to do that. I have 10 checkboxes named checkbox1, checkbox2, checkbox3,............checkbox10. I was trying to loop these checkboxes something like:

for i = 0 to 10
if checkbox(i).value=true then
msgbox checkbox(i).caption & " is checked"
else
msgbox checkbox(i).caption & " is not checked"
endif
next

but was not able to find the right way for doing this. Can somebody help me on this?

I tried searching for one but couldn't find the right one.

Thanks in advance
Praveen