Test for string of space chars?

[Robert Crandal]

I have a textbox on my main Userform that allows
someone type type in text. I would like to be able
to test for cases when "nothing" is entered into
the textbox, meaning no keystrokes were pressed
inside the textbox. Additionally, I would like to know
if the user pressed a sequence of blank or space characters.

For example, if someone presses the spacebar a couple
times, or the tab key, or a mixture of both, I would like
some function to tell me that the text string contains a
set of whitespace or blank characters.

Or would it just be easier to test if the string contains
ALL alphanumeric characters?

Thanks!

 

[AB]

Chekc out Len(Trim(userform.txtbxFName.text))
e.g.,
If Len(Trim(userform.txtbxFName.text))=0 then
MsgBox "Nope, you have to enter something for the First name"
End if

 

[AB]

I could be wrong, but perhaps Robert wants to validate text boxes -
that users enter something but blanks in there - hence trim actually
helps.
In the other post Rob had a code referencing the userform externally,
hence used the form reference too.

 

[Robert Crandal]

Thanks.....that works for me.

Chekc out Len(Trim(userform.txtbxFName.text))
e.g.,
If Len(Trim(userform.txtbxFName.text))=0 then
MsgBox "Nope, you have to enter something for the First name"
End if