Check for Empty Controls in Userform

[Ethan]

Hello all,

What code can I use to check if the textbox and combobox are empty or not?

[Bob Phillips]

Len(TextBox.Text)

and

ComboBox1.ListCount = 0

[Ethan]

Thank you for replying xld.

I solved it with the following code:


If Me.TextBox1.Value = "" Or Me.ComboBox1.Value = "" Then
MsgBox "Empty fields"
Exit Sub
End If