VBA Code for 'do nothing'

[ashleywanless]

Hi

I need to know how to write in VBA to do nothing, not exit sub just move on to the next bit of code.

I have created a userform with lots of checkboxes, i want the code to check each box but if it is not checked then move onto the next checkbox. Code below

Private Sub ExportCommand_Click()
If EDCB.Value = False Then ???????
Else
MsgBox "You checked the box"
End If
End Sub

Also my form contains 15 checkboxes but some of these are either/or checkboxes i.e i need to return an error if both are selected. I know this peice of code needs to run first but any ideas on how to structure this?

Im guessing something like the above but if checkbox1.value = true and (how can i write and)
checkbox2.value = true then
message box error

Please let me know if this is unclear
End Sub

 

[Nogslaw]

The easy fix is to change your logic:

Private Sub ExportCommand_Click()
If EDCB.Value = True Then
MsgBox "You checked the box"
End If
End Sub

For your second question about checking multiple conditions, you do just what you asked to do ... use AND:

If CheckBox1.Value = True AND Checkbox2.Value = True Then
MsgBox "Your Error Message Here"
End If

 

[Joe4]

You can shorten your first code to:

Private Sub ExportCommand_Click()
    If EDCB.Value = True Then MsgBox "You checked the box"
End Sub

 

[AlphaFrog]

You should add code for the paired checkboxes so that if one is checked, the other is unchecked e.g.

Private Sub CheckBox1_Click()
    If CheckBox1.Value Then CheckBox2.Value = False
End Sub

Private Sub CheckBox2_Click()
    If CheckBox2.Value Then CheckBox1.Value = False
End Sub

Both cant be selected. Then you wouldn't have to check if they are configured (error) properly.

 

[ashleywanless]

Perfect thanks so much all