I would like to know if it possible to make a custom dialog when there is a
error in a macro in a module. So, not for a single macro, but for all.

Thanks in advance, Gert-Jan

"Gert-Jan" schreef in bericht
.. .
I would like to know if it possible to make a custom dialog when there is a
error in a macro in a module. So, not for a single macro, but for all.

Thanks in advance, Gert-Jan



If you have a userform with 1 label and an OK-button, you're already there.

errorForm.Label1.Caption = "This is the error message"
errorForm.Show


All you have to do is to change the error messages in the subs you're
running.

This is a very simple solution; I could have created it myself :-)

What I want is a standard function in a module for errors.

Gert-Jan


"moon" schreef in bericht
. ..

"Gert-Jan" schreef in bericht
.. .
I would like to know if it possible to make a custom dialog when there is
a error in a macro in a module. So, not for a single macro, but for all.

Thanks in advance, Gert-Jan



If you have a userform with 1 label and an OK-button, you're already
there.

errorForm.Label1.Caption = "This is the error message"
errorForm.Show


All you have to do is to change the error messages in the subs you're
running.

Not in the sense of a global error handler.
You have to call a routine from each error handler you want to deal with.

NickHK

"Gert-Jan" wrote in message
.. .
This is a very simple solution; I could have created it myself :-)

What I want is a standard function in a module for errors.

Gert-Jan


"moon" schreef in bericht
. ..

"Gert-Jan" schreef in bericht
.. .
I would like to know if it possible to make a custom dialog when there
is
a error in a macro in a module. So, not for a single macro, but for all.

Thanks in advance, Gert-Jan



If you have a userform with 1 label and an OK-button, you're already
there.

errorForm.Label1.Caption = "This is the error message"
errorForm.Show


All you have to do is to change the error messages in the subs you're
running.