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 |
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. |
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. |
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. |
All times are GMT +1. The time now is 02:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com