Ensuring text is in a Userform before submitting

[MWhiteDesigns]

Currently i have userform an individual will fill out. A msgbox will populate if a required box is left blank asking to fill the information in. However people have figured out how to space it out, and bypass the error message. Is there a way to make sure characters are inputted and not spaces?

I am using the code below currently,

If NameTextBox.Value = "" Then
MsgBox "Name cannot be blank.", , "Name error"
Exit Sub
End If

 

[mikerickson]

You could test

 If Application.Trim(NameTextBox.Text) <> vbNullString Then