Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error dialog
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error dialog
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error dialog box meaning and how to find error | Excel Worksheet Functions | |||
How to avoid an error dialog | Excel Programming | |||
How to prevent the MS Excel error dialog by errorhandling ? | Excel Programming | |||
Common Dialog Error ! (Please Help me ! urgently) | Excel Programming | |||
Common Dialog Error | Excel Programming |