Is it enough to insert the On Error GoTo XXXXX procedure at the begining of every sub, in order to trigger XXXXX whenever an error occurs?
Printable View
Is it enough to insert the On Error GoTo XXXXX procedure at the begining of every sub, in order to trigger XXXXX whenever an error occurs?
If XXXXX is A label somwhee in your code... Yes.
But todo Propper Error handling use an area at the end of exch sub/function to handle the expected errors en display an error message if the error was unexpected or critical for your programn flow.
To speed up this process you can download M-Z tools for VBA (free)
to generate the basic error handling code.