Limiting the scope of On Error

A

Android

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.
 
B

Bob Phillips

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)
 
A

Android

Thank you.

Android.

Bob Phillips said:
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)
Click to expand...
 
Top