Input box.

[Elaine Johnson]

I have an input box that I am using in a macro that
requires the user to input an age between 18 and 65. I
made it so they could only input ages in that range by
using a loop with <>. And that works fine. If they input
15, it just loops.

However, if they accidently try to input anything but a
number (i.e. the letter a) they get a mismatch error. Is
there some way for me to write code that will allow them to
input ONLY numbers. I'm hoping for something similar to
what I've done already (just to loop until they put in a
number between 18 - 65.)

Thanks for looking at this.

Elaine Johnson

 

[doj]

use typename(input box value) to ensure the input is an integer