Validating an Option Button and Multiple Checkboxes

[TellM1955]

I have a user form where I have a 2 Optionbutton group (Early and Late) and 5 Checkboxes, 1 for each day of the working week. Below is my attempt at the code however, it just doesn't work. What I'm expecting is that if Early is true and any of the days are selected the message box pops up as a warning. Any guidance on where I'm going wrong would be appreciated.

At present I've got

If OptionEarly = True And (ChkMon = True Or ChkTue = True Or ChkWed = True Or _
ChkThu = True Or ChkFri = True) Then _

MsgBox "Has permission been provided"

End If

 

[DanteAmor]

It should be like this, without the last underscore

  If OptionEarly = True And (ChkMon = True Or ChkTue = True Or ChkWed = True Or _
    ChkThu = True Or ChkFri = True) Then
    MsgBox "Has permission been provided"
  End If

 

[TellM1955]

Dante, thanks.

 

[DanteAmor]

Im glad to help you, thanks for feedback.


It can also be reduced, if you consider that False is equal to 0 and true is not equal to 0:

  If OptionEarly = True And ((ChkMon + ChkTue + ChkWed + ChkThu + ChkFri) <> 0) Then
    MsgBox "Has permission been provided"
  End If