Results 1 to 2 of 2

Thread: On Error (2003)

  1. #1
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Stuck at work..., Missouri, USA
    Posts
    248
    Thanks
    0
    Thanked 0 Times in 0 Posts

    On Error (2003)

    I have some code that is guaranteed to generate one error and possibly two.

    For the first, I use <pre>On Error GoTo <my label></pre>

    For the second I've tried <pre>On Error GoTo <my other label></pre>

    After the first error, it goes to the first label, but when the next error gets thrown, I get an error message instead of it moving to the second label.

    Is it possible to have multiple On Error GoTo statements?
    <font face="Comic Sans MS">Morgan Erickson</font face=comic>
    morgan.erickson@sprint.com
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>-From <img src=/S/flags/Colorado.gif border=0 alt=Colorado width=30 height=18> but living in <img src=/S/flags/Missouri.gif border=0 alt=Missouri width=30 height=18>...and working in Kansas.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: On Error (2003)

    You can use different On Error GoTo statements, but you must take care to end each error handling section (the part starting with the label you jump to) with either Exit Sub or with one of the Resume statements (Resume, Resume Next or Resume <label>).
    Another option is to let one error handler handle all errors:

    Sub MyProc()
    On Error GoTo ErrHandler
    ...
    ...
    Exit Sub

    ErrHandler:
    Select Case Err
    Case ...
    ...
    Case ...
    ...
    Case Else
    ...
    End Select
    End Sub

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •