How to check for empty text box 1

[hondaman2003]

I need to use a select case to check for not only multiple values but one option is that the text box is blank.

Select case txtTextBox
case "value1", "value2", "value3", null
msgbox "worked"
case else
msgbox "did not work"
end select

How can I make this work?

 

[PHV]

Select Case Trim(txtTextBox & "")
case "value1", "value2", "value3", ""
...


Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[hondaman2003]

Thank you for that suggestion. It doesn't work either.

 

[hondaman2003]

I'm sorry, I didn't notice your 'trim' statement. Yes, this did work!

Thank you so much!