Checking for certain value

[SonicBoomAu]

Is there an easy way of checking to see if a value is between a certain range. For Example, I want to see if a value is between "A" and "Z".

 

The only way I can think of is to individually check every letter(if strAlpha = "A" then......). Where as what I would like to do is if strAlpha =< "A" or strAlpha => "Z".

[ThePentiumGuy]

Convert each thing to ASCII (I beleive 65 is 'A' and 91 is 'Z') and see if the value's in between. Google around for an ASCII key table :D

[HJB417]

or a regex but ThePentiumGuy's method is better in this scenario.

[SonicBoomAu]

Thank You

 

Thank you that worked.

 

If strThirdAlpha >= Chr(65) And strThirdAlpha <= Chr(90) Then

 

I didn't have to convert the original string which is handy.

:D

 

ACSII table:

http://www.asciitable.com/