you could test for the value of the interger. something like this:

If i 0 or <=100 then
'do something here
Else
MsgBox "Please pick integer in the range of 1-100"
End If


....you could also use a SELECT....CASE block