I have a userform with multiple text boxes. I would like a message box to appear if there is something in either TextBox2 and/or TextBox3, but nothing in TextBox1. I would also like it if the user was not able to continue if this occurs.

This is my current code:

```
Private Sub SubmitCommandButtom_Click()
If Len(TextBox1) = "" And Len(TextBox2) > 0 Or Len(TextBox3) > 0 Then
    MsgBox "Unit Number must be entered to continue!"
End If
Sheets("Uneven Split Job Aid").Range("A2") = TextBox1.Value
Sheets("Uneven Split Job Aid").Range("B2") = TextBox2.Value
Sheets("Uneven Split Job Aid").Range("C2") = TextBox3.Value

```

This code currently only generates the message box when there is a value in Textbox3 and not in TextBox1, it doesn't matter if anything is in TextBox2. I would like it to check TextBox2 for a value as well. Also, when I click Ok on the message box, the Sub continues to run and inserts the values of the TextBoxes onto the worksheet. I would like if that did not happen if a message box appears.

Thanks for any help in advance!