Maybe, I'm missing something. I thought that he was trying to return a
number between 1 and 5.

Paul

------------------------------------------------------------------------------------------------------

According to help:

If the user clicks OK or presses ENTER , the InputBox function returns
whatever is in the text box. If the user clicks Cancel, the function returns
a zero-length string ("").

you must have Ans dim'd as a number.