VBA code error checking

[Ozroly]

I'm making a userform that has multiple text boxes, for Example Combobox1 = ReasonForRequestField and Combobox2 = Requestnotcreatedfield, if Combobox1 = Reason 1 or Reason 2 then the validation will require the user to select an outcome from Combobox2, but if Combobox1 = Reason 3 or 4 then Combobox2 is not required.

i have tried the validation below but it wont allow me submit with Reason 1 in Combobox1

If Me.ReasonForRequestField.Value = "Reason1" Then

MsgBox " Please select a reason from Drop Down below " , vbExclamation, " Request not created field "

Me.Requestnotcreatedfield.SetFocus

Exit Sub

End If

i found this example on here but couldnt figure out how to adapt the variables to my form

If combobox1.Text = "1 - 2 yr" And (CDbl(textbox2.Value) < 1 Or CDbl(textbox2.Value) > 2) Then MsgBox ("Enter correct value") ElseIf combobox1.Text = And Then... End If

i hope i explained what i'm after ok, Any help would be Greatly appreciated

Thanks.

 

[Legacy 456155]

You could model it along these lines.

Private Function FieldsValidated() As Boolean
    If Combobox1 = "Reason 1" Or Combobox1 = "Reason 2" Then
        If Combobox2 = vbNullString Then Exit Function
    End If
    FieldsValidated = True
End Function

Private Sub cmd1_Click()
    If Not FieldsValidated Then msgBox "Message"
End Sub