InputBox Returns Error if Letter input is before letter 'Z'

Hi,

I have a code that hides columns based on what the user puts as the starting column (end column is fixed).
But I don't want them to hide anything before column 'Z'. How do I have my code distinguish if the value input is earlier than 'Z' in the alphabet?
I'd then have an error message pop up and exit the sub

Thanks!

Originally Posted by cytop

It'd help to see what you have... but you can simply check as "Y" < "Z" (but "y" is not < "Z")...

basically i need a code that would return an error if the letter input is A through Y
I'm trying to avoid having to list 25 separate If functions for each letter
Is this possible

Thanks!

It is very possible - but it'd still help to see your existing code.

Originally Posted by xladept

Something like:

Please Login or Register  to view this content.

Thanks! the Asc makes 100% sense --
Though, the value returned is based on the first character, and some columns have 2 charaters, so if someone is inputting AB i'd like it to be allowed

But I just added this and it made it work

Please Login or Register  to view this content.

Thanks again!