find out if its a character

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

Hi every one,

I'm trying to find out if there is such a
function 'islpha' for vba. What I'm trying to do is to
check the textbox if it contains these character (a-z, A-
Z). If there isn't,how can I check to see if the text box
have these character.?

Thanks for the help.

mike
 
mike said:
I'm trying to find out if there is such a
function 'islpha' for vba. What I'm trying to do is to
check the textbox if it contains these character (a-z, A-
Z). If there isn't,how can I check to see if the text box
have these character.?
Click to expand...


Not clear. Do you want to check if the text box only has
alpha characters, if it has no alpha characters, or what?

To check for all alpha:

If Not Me.textbox Like "*[!a-z]*" Then

To check for all non alpha characters:

If Not Me.textbox Like "*[a-z]*" Then
 
Back
Top