This documentation is archived and is not being maintained.

How to: Retrieve Information from an Error Object 

When a run-time error occurs, the properties of the Err object are filled with information that uniquely identifies the error and information that can be used to handle the error.

The Err object's properties are reset to zero or zero-length strings ("") after an On Error Resume Next statement and after an Exit Sub or Exit Function statement within an error-handling routine. The Clear method can be used to explicitly reset Err.

NoteNote

  The options available in dialog boxes, and the names and locations of menu commands you see, might differ from what is described in Help depending on your active settings or edition. This Help page was written with General Development Settings in mind. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings.

To retrieve information from an error object

  1. You can filter for specific errors. This example checks to see if the error is a FileNotFound error and reacts if it is.

    If Err.Number = 53 Then
      MsgBox("File Not Found")
    End If
    
    
  2. You can also examine specific properties of the error object, such as Description, Erl, HelpContext, Helpfile, LastDLLError, Number, and Source. This example displays the description in a message box.

    MsgBox(Err.Description)
    
    

See Also

Show: