Simple Error Handling

[Bob1980]

Hi,

I have a simple questions. I'm pretty new to VBA and want to include good error handling techniques in my code. Currently, I'm trying to write a simple module that will have an input box to allow a user to enter in a number, and then print/insert that number into a cell. But, there are two issues with my code. Please see below:

Please Login or Register  to view this content.

First, as you can see, if a person places an integer inside of the input box; then a mismatch error will occur. I was trying to map the error, or handle the error, by using a the

Please Login or Register  to view this content.

line. Before that, I was trying

Please Login or Register  to view this content.

then the code will resume.

Second problem, there's a vbcancel button in the input box. If I press "cancel", I get an error message. I tried the following:

Please Login or Register  to view this content.

I think it's the same problem above, but I don't know. Any help would be appreciated.

[Norie]

Declare n as Variant instead of Integer.

Oh, and you don't need On Error Goto.

[Bob1980]

Your awesome, this also handled the "vbCancel" issue. Thanks. FYI,

Please Login or Register  to view this content.