vbCancel when 2 is acceptable 1

[chadrj]

How can I allow for a user to enter "2" in an input box as the value and have the result differ from when the cancel button is clicked? Apparently vbCancel = 2.

Thanks,
Chad

Never try to teach a pig to think. It doesn't work and it annoys the pig.
-Anonymous

 

[PHV]

Doesn't the InputBox function returns an empty string when the cancel button is clicked ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[chadrj]

Yes, it does, but I am receiving the input as an integer... Would just changing it to a string value fix it...? I will try...

Sure does. That was stupid easy! Thanks for your help!



Never try to teach a pig to think. It doesn't work and it annoys the pig.
-Anonymous