Placing a Resume Next Statement in Your Error Handler : Error Handler « Language Basics « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Language Basics
  3. Error Handler

Placing a Resume Next Statement in Your Error Handler

 
Sub TestResumeNextInError()
    On Error GoTo TestResumeNextInError_Err
    Kill "AnyFile"
    If Err.number = 0 Then
    Else
        msgBox "We Didn't Die, But the Error Was: " & Err.Description
    End If

    Exit Sub
TestResumeNextInError_Err:
    Resume Next
End Sub








Related examples in the same category

1.An Example of Code Without Error Handling
2.A Simple Error-Handling Routine
3.An Example of Error Handling Using the On Error GoTo Statement
4.Ignoring an Error and Continuing Execution
5.Using Resume Conditionally Based on User Feedback
6.Using the Resume Statement to Specify Where Execution Continues After an Error Occurs
7.Looking Up the Call Stack for a Previous Error Handler
8.Read user choice when dealing with error
9.error handling by checking the Error code
10.EBEngine.Errors