Thread: Error dialog
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
moon[_7_] moon[_7_] is offline
external usenet poster
 
Posts: 53
Default Error dialog


"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.