How to set a restriction for the content input in Inputbox

[qzqzjcjp]

Hey, I am now using a inputbox in my macro code. But I have no idea about how I can restrict the content users input.

My purpose is set a restriction that only allow alphabet can be input in the InputBox, such as AA,Ab,cB,dd. Any numbers, other signs and even space are not allowed.

Thank you so much as I am a newbie in macro.

[ranman256]

You cant restrict what they type in INPUTBOX, but you can review it after...

Please Login or Register  to view this content.

[qzqzjcjp]

Thank you very much.
But your code is for numbers, I want alphabets...

[jindon]

Something like

Please Login or Register  to view this content.

[qzqzjcjp]

Cool, that's what I want. But it extents to another question.
What's the difference between "*[!A-Za-z]*" and "[!A-Za-z]"?? I tried to input @@ in the code without "*", it passed without alert. But yours code is ok.
Thanks again.

[jindon]

"*[!A-Za-z]*"
Any length of character(s) without non-alphabets.

If you want to restrict the entry to 2 characters then

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

[qzqzjcjp]

I am still confused. For the code below:

Please Login or Register  to view this content.

I entry 111, it still can pass without error. Why?
Thanks.

[jindon]

Of course.

Your condition is targeting just one character in the inputobox.
If it is more than one, it goes through.

What do you want?

[qzqzjcjp]

Got it!!! Actually, [!A-Za-z] includes two conditions: 1,one character; 2,not alphabet。 The error alert shows only when these two conditions both are satisfied. As long as one of it is broken, it goes through. Right?

[jindon]

Correct and that is the difference from "*[!A-Za-z]*".

[qzqzjcjp]

Thank you tons!!!

[jindon]

You are welcome and now you can mark this thread as "Solved".