MsgBox instead of compile error

[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

 

[Bob Phillips]

Try

OnError Goto errhandler

'your code

Exit Sub

errhandler:
Msgbox "Error"

 

[KP]

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

 

[Bob Phillips]

Really, I am surprised, that is just a label.

 

[KP]

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