Hi all,

Just have a question.

I have developed so many subroutines in many modules of a workbook,
including an error handling procedure which handles any unhandled errors..
Instead of writing an error-handling routine within all subroutines, is it
possible to write an error-handling routines once in a workbook so as to
apply to all other subroutines?

By the way, is there a syntax something like "On Error GoTo <Subroutine" or
"On Error GoSub ... " in VBA?

Thanks a lot.

Frederick Chow

In short no (to the best of my knowledge). Every sub must have an error
handler in it. However as to the second part of your question sure... I have
a standard error handling module that I use in all of my projects. I add the
module and my error handler just calls a sub within it. There are a bunch of
standard things like resetting the application level settings and a form is
displayed showing the nature of the error...

Private Sub TestStuff()
On Error GoTo ErrorHandler
'Your Code Here
Exit Sub

ErrorHandler:
modErrors.HandleError
End Sub
--
HTH...

Jim Thomlinson


"Frederick Chow" wrote:

Hi all,

Just have a question.

I have developed so many subroutines in many modules of a workbook,
including an error handling procedure which handles any unhandled errors..
Instead of writing an error-handling routine within all subroutines, is it
possible to write an error-handling routines once in a workbook so as to
apply to all other subroutines?

By the way, is there a syntax something like "On Error GoTo <Subroutine" or
"On Error GoSub ... " in VBA?

Thanks a lot.

Frederick Chow

So is there a syntax like "On Error GoSub HandleError"? This should have
been much more convenient.


"Jim Thomlinson" wrote in
message ...
In short no (to the best of my knowledge). Every sub must have an error
handler in it. However as to the second part of your question sure... I
have
a standard error handling module that I use in all of my projects. I add
the
module and my error handler just calls a sub within it. There are a bunch
of
standard things like resetting the application level settings and a form
is
displayed showing the nature of the error...

Private Sub TestStuff()
On Error GoTo ErrorHandler
'Your Code Here
Exit Sub

ErrorHandler:
modErrors.HandleError
End Sub
--
HTH...

Jim Thomlinson


"Frederick Chow" wrote:

Hi all,

Just have a question.

I have developed so many subroutines in many modules of a workbook,
including an error handling procedure which handles any unhandled
errors..
Instead of writing an error-handling routine within all subroutines, is
it
possible to write an error-handling routines once in a workbook so as to
apply to all other subroutines?

By the way, is there a syntax something like "On Error GoTo <Subroutine"
or
"On Error GoSub ... " in VBA?

Thanks a lot.

Frederick Chow