VB checkbox checked?

I have a series of checkboxes, each one is linked to its own cell, that all need to be checked before my macro can move on.

I need a VB script that will look at a range of cells and if each one is marked "True" to execute the next part of the macro. Or look at my series of checkboxes and if they are all checked to execute the next part of the macro.

I could use a series of if-and statements to look at each cell but this could end up being a very long string of statements.

Is there a way to check if a range of cells or checkboxes are all true/checked?

thanks leith, that code looks good but i think it needs modified a little.

I have groups of checkboxes, when you've checked all the checkboxes in one group the user is moved down to the next group of checkboxes. So i can't check the global checkbox status, I need to check specific groups of checkboxes. such as "checkbox5:checkbox10", and at the next group "checkbox11:checkbox20"

I was going to try replaceing "activesheet.checkboxes" here:

Please Login or Register  to view this content.

with a range of checkboxes but i dont know the syntax. I'm pretty new to VB.

Thanks for helping!

sorry leith,
i actually can't post it cause of company property and all. I just follow the rules.

here is my code so far though:

Please Login or Register  to view this content.

this is working out it seems. Now i just need it figure out how to make it also look at cells A1710:A1714. I tried adding another "For Each..." part under the current one but that didn't work out. My "cboxvalue" value came back as "0". I'll just keep tinkering.

thanks though for your help, I used the code you gave me to come up with this one. Appreciate the help.