MsgBox instead of compile error

  • Thread starter Thread starter KP
  • Start date Start date
K

KP

Hi,

When running a macro I sometimes get an error due to the fact that the
Webpage from which I receive some updates to the macro is down.

Is it possible in stead of the well-known 'comile-error' that I can have my
own message box to pop up. At least before the compile error message?
How should such a macro be created. I presume it should be in the beginning
of the macro.

Thanks for any suggestions.


Kaj Pedersen
 
Thanks you very much, it works.
I figured out that in my version of Excel I had to use the word
"ErrorHandler" .
Otherwise it wouldn't work.

Kaj Pedersen
 
Hi Bob,

I am sorry . Now I see this was a misinformation. I don't know what happened
.. Now I can name it what ever I like.
Thanks again.

Kaj Pedersen
 
Back
Top