1. Sub test
    2. On Error GoTo ErrorHandler
    3. ErrorHandler:
    4. If Err.Number <> 0 Then
    5. Msg = "Error # " & Str(Err.Number) & " was generated by " _
    6. & Err.Source & Chr(13) & "Error Line: " & Erl & Chr(13) & Err.Description
    7. MsgBox Msg, , "Error", Err.HelpFile, Err.HelpContext
    8. End If
    9. end sub