Article ID: 148358
Article Last Modified on 10/11/2006
Sub ErrorTest ()
Dim x as Integer ' Declare variable.
On Error Goto ErrorTest_Error
x = 5 / 0 ' Divide by zero error.
Exit Sub
ErrorTest_Error:
Debug.Print "Error occurred in line #" & Erl
Resume Next
End Sub
ErrorTest
Sub ErrorTest ()
Dim x as Integer ' Declare variable.
10: ' NEW LINE!!!
On Error Goto ErrorTest_Error
11: ' NEW LINE!!!
x = 5 / 0 ' Divide by zero error
12: ' NEW LINE!!!
Exit Sub
ErrorTest_Error:
Debug.Print "Error occurred in line #" & Erl
Resume Next
End Sub
ErrorTest
Keywords: kbprb kbprogramming KB148358