checking the value of multiple checkboxes before continuing

[rob737]

Good Morning Forum </SPAN>
I would like some help with nesting a loop to check the condition of checkboxes on my form
</SPAN>
Excel : 2010 </SPAN>
Operating System: Windows 7 </SPAN>
Forum Experience: Novice </SPAN>
Program Experience: Novice </SPAN>

I have three check boxes on a form, when all 3 are true I would like to call nextSub().</SPAN>

For I = 1 to 10 </SPAN>

If userform1.checkbox1.value = True </SPAN>
And if </SPAN>
userform1.checkbox2.value = True </SPAN>
And if </SPAN>
userform1.checkbox2.value = True then </SPAN>
nextSub


other stuff </SPAN>​

next I </SPAN>

hope someone can help me out here</SPAN>

Many thanks </SPAN>
Best Regards</SPAN>
Rob </SPAN>



Good Morning Forum </SPAN>
I would like some help with nesting a loop to check the condition of checkboxes on my form </SPAN>
Excel : 2010 </SPAN>
Operating System: Windows 7 </SPAN>
Forum Experience: Novice </SPAN>
Program Experience: Novice </SPAN>
I have three check boxes on a form, when all 3 are true I would like to call nextSub().</SPAN>
For I = 1 to 10 </SPAN>
If userform1.checkbox1.value = True </SPAN>
And if </SPAN>
userform1.checkbox2.value = True </SPAN>
And if </SPAN>
userform1.checkbox2.value = True then </SPAN>
nextSub</SPAN>
next I </SPAN>

hope someone can help me out here</SPAN>

Many thanks </SPAN>
Best Regards</SPAN>
Rob </SPAN>

 

[mikerickson]

If (Checkbox1.Value And CheckBox2.Value) And CheckBox3.Value Then
    Call nextSub
End If

 

[rob737]

hi mike

Many thanks as always

Regards
Rob