find out if its a character

[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

 

[Phil Hunt]

isNumeric function ?

 

[Marshall Barton]

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

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