Code continues to run when it should have stopped & exit sub

[ipbr21054]

Part of my code is to check whether either of my two checkboxes have a selection.

I have CheckBox1 & Checkbox2

This is what i have in place BUT when neither of the checkboxes have been selected the following code should stop BUT it continues to run.

    If CheckBox1 & CheckBox2 = False Then
    MsgBox "NEITHER CHECKBOX WAS SELECTED", vbCritical, "NO CHECKBOX WAS SELECTED MESSAGE"
    Exit Sub
    End If

 

[ipbr21054]

Update
This worked if i wrote it for 1 checkbox so how is it correctly written to allow BOTH checkboxes in one line of code without having to write the code twice

    If CheckBox1 = False Then
    MsgBox "NEITHER CHECKBOX WAS SELECTED", vbCritical, "NO CHECKBOX WAS SELECTED MESSAGE"
    Exit Sub
    End If

 

[RoryA]

If CheckBox1 = False and checkbox2 = false then

Should do it

 

[ipbr21054]

It does thanks

 

[ipbr21054]

@RoryA can you advise on this also please.

Clear / Reset Checkbox on worksheet when userform has a submission

Morning. I have a worksheet with Checkbox1 & CheckBox2 The user opens the userform & enters a value into TextBox1 etc The user then uses the commandbutton code to send TextBox1`value to worksheet. At the same time i would like CheckBox1 & Checkbox2 on the worksheet cleared / reset. This is...

www.mrexcel.com