Greetings !

I have an InputBox.

How do I distinguish between a valid input value of 2 and
the user clicking on the "Cancel" button ?

This worked just FINE - until I entered a value of 2 !

Ans = InputBox( _
"Enter a value between 1 and 5, myTitle, TP)
If Ans = vbCancel Then Exit Sub
TP = Ans