The property values in the Err object reflect only the most recent error. The error-handling routine should test or save relevant property values in the Err object before any other error can occur or before a procedure that might cause an error is called.
EXCEL VBA ON ERROR GOTO LINE NUMBER CODE
It is a section of code marked by a line label or line number.Įrror-handling routines rely on the value in the Number property of the Err object to determine the cause of the error. After an error is handled by an error handler in any procedure, execution resumes in the current procedure at the point designated by the Resume statement.Īn error-handling routine is not a Sub procedure or Function procedure. If no inactive, enabled error handler is found, the error is fatal at the point at which it actually occurred.Įach time the error handler passes control back to a calling procedure, that procedure becomes the current procedure. If the calling procedure's error handler is also active, control passes back through previous calling procedures until an enabled, but inactive, error handler is found. If the calling procedure has an enabled error handler, it is activated to handle the error. Control returns to the calling procedure. If an error occurs while an error handler is active (between the occurrence of the error and a Resume, Exit Sub, Exit Function, or Exit Property statement), the current procedure's error handler can't handle the error. If you don't use an On Error statement, any run-time error that occurs is fatal that is, an error message is displayed and execution stops.Īn "enabled" error handler is one that is turned on by an On Error statement an "active" error handler is an enabled handler that is in the process of handling an error. Use this form rather than On Error GoTo when accessing objects.ĭisables any enabled error handler in the current procedure. Specifies that when a run-time error occurs, control goes to the statement immediately following the statement where the error occurred and execution continues. The specified line must be in the same procedure as the On Error statement otherwise, a compile-time error occurs. If a run-time error occurs, control branches to line, making the error handler active. The line argument is any line label or line number. The On Error statement syntax can have any of the following forms: StatementĮnables the error-handling routine that starts at line specified in the required line argument. On Error GoTo line On Error Resume Next On Error GoTo 0 Enables an error-handling routine and specifies the location of the routine within a procedure can also be used to disable an error-handling routine.
0 kommentar(er)
