Inputbox cancel button error.

[abhay_547]

Hi All,

I have the below code which I use to get some input from the user using input box when the user clicks on the cancel button it shows an error.

Please Login or Register  to view this content.

I tried to use below but still the user faces the error. Please help.

Please Login or Register  to view this content.

Thanks a lot for your help in advance.

[DonkeyOte]

Rather than use InputBox use Application.InputBox with Type 1 - this way W & H will both be 0 (exit/cancel) and you can validate on that basis.

[Leith Ross]

Hello abhay_547,

The code works fine for me and I'm using Excel 2003.

[DonkeyOte]

The code works fine for me and I'm using Excel 2003.

Given the Long declarations the Exit/Cancel on a standard InputBox should throw a Debug, no ? If declared as Variant then it would work.

Given the input type is defined (number) Application.InputBox would IMO be preferable as it would capture all erroneous entries at point of entry (not just Exit/Cancel)

[abhay_547]

Hi Ote,

Thanks a lot for your reply, can you please provide me with an example of what you are suggesting.

Thanks a lot for your help in advance.

[DonkeyOte]

The link provided should have been sufficient.

Please Login or Register  to view this content.

You can then validate the variables to ensure the Longs are within acceptable boundaries (Cancel/Exit will return 0)

[abhay_547]

Hi Ote,

Thanks a lot for your reply, I have tested the code and it works fine. I have incorporated the same in my main code. Here is it :

Please Login or Register  to view this content.

Thanks a lot