Get input from user using application.inputbox. Input should be number and can be 0

hi,

i have a situation where i am trying to get input from the user on the number of days to add to "something". The user can input a "0"...zero...as a possible anser. The problem is this.

I look at the value input by the user to determine if the user hit the cancel button. This i believe evaluates to False or something. My problem is that if the user hits cancel or inputs a ZERO .......they both get evaluated the same. Below is the code i am using.

Any ideas?

Please Login or Register  to view this content.

You can evaluate via TypeName function
e.g

Please Login or Register  to view this content.

Returns "Boolean" when Cancel button clidked.

so i should do a test like the following

Please Login or Register  to view this content.

What is the typename if the user input an actual number..........

thanks for your help!

It should return "Double" when number is input.

Please Login or Register  to view this content.

You will also need to evaluate when
Decimal, negative number etc...