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?