inputbox must be x

[288enzo]

I have two inputboxes.

    strArea = InputBox("Area? (80, 82, 83, 84, 87)")
    strQtr = InputBox("Quarter? (1,2,3,4)")

In both, how to I force a user to enter one of the options I have listed?

Thank you

 

[RoryA]

You have to validate whatever the input is, and react accordingly. There is no built-in option to limit an inputbox like that. (you could use a userform instead)