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!

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


On Dec 30, 10:42*am, "Robert Crandal" wrote:
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!

Using Trim may remove the space(s) he wants to detect. I would just do
something like this:

If txtWhatever.Value="" then

No need to specify the userform name if the code is in the userform module.

"AB" wrote in message
...
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

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.

On Dec 30, 11:39*am, "Jim Rech" wrote:
Using Trim may remove the space(s) he wants to detect. *I would just do
something like this:

*If txtWhatever.Value="" then

No need to specify the userform name if the code is in the userform module.

"AB" wrote in message

...
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

Thanks.....that works for me.

"AB" wrote in message
...
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