docs:programming:office_vba:error_handling [hartungdesign.net wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== Error Handling ======

===== typical example =====
<code vb>
Private Sub someSub()
On Error Goto HandleError

  ' Attempt something here, possibly
  ' generating an error

ExitSub:
  ' Do cleanup here
  Exit Sub

HandleError:
  ' Do something about the error
  Goto ExitSub
End Sub
</code>

===== ignore errors and keep going =====
<code vb>
Private Sub someSub()
On Error Resume Next

  ' Attempt something here, possibly
  ' generating an error
End Sub

</code>

===== alternate HandleError =====
<code vb>
HandleError:
Debug.Print "Error: " & _ ' the underscore (_) allows code to continue on the next line
Err.Description & ",(" & Err.Number & ")"
Resume Next
</code>

===== Resume options =====
  * **Resume**
    * this will pick up with the same line causing the error, as if to keep trying
  * **Resume Next**
    * resume normal program functionality at the line after the one causing the error
  * **Resume <line>**
    * where <line> is the line number to jump to