## isnumeric for characters?? ##

[rudders]

Hi all

is there a function in VBE to check if an input is a character? (i.e a-z or A-Z)...
I can use isnumeric to check numbers, but i wondered if there is a way to do this for characters?

cheers

 

[Oorang]

no but you can do this:
Sub a()
X = InputBox("Enter One Character to Test")
If Asc(X) > 31 And Asc(X) < 65 Then MsgBox "It's nonnumeric and nonalphabetic."
End Sub

EDIT:
This does not capture ALL nonnumeric and nonalphabetic characters, the ascii codes here:
http://www.lookuptables.com

 

[Andrew Poulsom]

Yes there is:

Option Compare Text

Sub Test()
    MsgBox "a" Like "[A-Z]"
End Sub

 

[rudders]

sorry andrew,

how could i use your method if i have

X = inputbox ("enter a character")

?? where do i put the LIKE function??

 

[Andrew Poulsom]

sorry andrew,

how could i use your method if i have

X = inputbox ("enter a character")

?? where do i put the LIKE function??

Like this:

If X Like "[A-Z]" Then
' OK
Else
' Not Ok
End If

Don't forget Option Compare Text at the top of your module.