error routine

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Janis - 19 Sep 2006 23:46 GMT

Thanks for this error handler macro. I have one question about it. It is
for a user form.
Where it says "exit sub" , what is the exit sub for? The end sub is the end
of the subrouting which it reaches if there is no error, but if there is an
error doesn't it go to the error handler? so why does it exit the sub?
Thanks,

Private Sub CommandButton1_click()

on Error goto ErrHandler

Code
xxxxxxx

Exit Sub

ErrHandler:
Select Case Err.Number
Case 9
resume
Case Else
MsgBox Err.Number & " " & Err.Description
End Select
End Sub

Reply to this Message

Bob Phillips - 19 Sep 2006 23:59 GMT

So that it doesn't drop into the error handler by defaulter even though
there is no error.

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Thanks for this error handler macro. I have one question about it. It is
> for a user form.
[quoted text clipped - 20 lines]
> End Select
> End Sub

Reply to this Message

Tom Ogilvy - 20 Sep 2006 00:18 GMT

The exit sub is so it doesn't go through the error handler when there is no
error.

Errhandler:

is just a label that is jumped to if an error occurs - it doesn't mark the
end of the "good" code. If you don't have the exit sub, the code will
always pass through the error handler.

Signature

Regards,
Tom Ogilvy

> Thanks for this error handler macro. I have one question about it. It is
> for a user form.
[quoted text clipped - 22 lines]
> End Select
> End Sub

Reply to this Message