Thread: Error dialog
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Error dialog

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.