find out if its a character

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
 
M

Marshall Barton

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
 
Top