Limiting the scope of On Error
 

I would like to apply On Error error checking within a specific procedure
only.

If I do, something like....

Sub Test()

On Error Goto ErrorHandler
- code -
- code -

ErrorHandler:
msgbox "dddd"
End Sub

Will On Error still be active after this procedure finishes? If so, is
there a way to switch off On Error? I want to handle the error in this
routine, but I want the application to stop and show the error everywhere
else.

Regards,

Android.

Limiting the scope of On Error
 

On Error will still be active if you call another procedure, but when the
code terminates, it dies. Any further code run afterwards will return to the
default error handling.

You can return error handling to the default with

On Error Goto 0

If you want to ignore errors (sic!), or trap them individually, use

On Error Resume Next

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Android" wrote in message
...
I would like to apply On Error error checking within a specific procedure
only.

If I do, something like....

Sub Test()

On Error Goto ErrorHandler
- code -
- code -

ErrorHandler:
msgbox "dddd"
End Sub

Will On Error still be active after this procedure finishes? If so, is
there a way to switch off On Error? I want to handle the error in this
routine, but I want the application to stop and show the error everywhere
else.

Regards,

Android.

Limiting the scope of On Error
 

Thank you.

Android.

"Bob Phillips" wrote in message
...
On Error will still be active if you call another procedure, but when the
code terminates, it dies. Any further code run afterwards will return to
the
default error handling.

You can return error handling to the default with

On Error Goto 0

If you want to ignore errors (sic!), or trap them individually, use

On Error Resume Next

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Android" wrote in message
...
I would like to apply On Error error checking within a specific
procedure
only.

If I do, something like....

Sub Test()

On Error Goto ErrorHandler
- code -
- code -

ErrorHandler:
msgbox "dddd"
End Sub

Will On Error still be active after this procedure finishes? If so, is
there a way to switch off On Error? I want to handle the error in this
routine, but I want the application to stop and show the error
everywhere
else.

Regards,

Android.