VBA - Check UserForm Text/Combo Box for Values

[sprigelz]

Good day!

I would like some help crafting some VBA code to check 2 fields within a Userform and if both have a value, then to display an error, otherwise execute the rest of the code.

So basically, if the user selects a value from the drop down AND types something in the Last Name textbox and clicks Search, I need an error to display stating "Please only input values into 1 block" or something of that sort. Otherwise if there are only values in one or the other, and the user clicks search, continue with the next piece of the code.

Any assistance would be greatly appreciated!

Full Name - ComboBox - ComboBox1
Last Name - Text Box - TextBox1

 

[sprigelz]

Apologies, I have solved this on my own.

Private Sub CommandButton1_Click()

If ComboBox1.Value <> "" And Trim(TextBox1.Text) <> "" Then
    MsgBox "Bad!!"
Else

Unload Me

End If

End Sub