Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please help with On Error GoTo
Hello all,
In my code, I inserted an error trapping code in case an error has occurred. If there is an error, the code will jump to the error handler section and execute the code in the ErrorHandler section. So the following is what I have: On Error Goto ErrorHandler 'The code in between ErrorHandler: Msgbox "An error has occurred please contact the IT department", vbCritical Somehow, the code from above executes the code in the ErrorHandler: section even there is no error. The code however did jump right into the ErrorHandler section when there was an error. Did I do something wrong? Please help. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please help with On Error GoTo
One way:
ErrorHandler: If Err.Number 0 Then Msgbox "An error has occurred please contact the IT department", vbCritical End If If there is no error is will skip the message box. "Accesshelp" wrote in message ... Hello all, In my code, I inserted an error trapping code in case an error has occurred. If there is an error, the code will jump to the error handler section and execute the code in the ErrorHandler section. So the following is what I have: On Error Goto ErrorHandler 'The code in between ErrorHandler: Msgbox "An error has occurred please contact the IT department", vbCritical Somehow, the code from above executes the code in the ErrorHandler: section even there is no error. The code however did jump right into the ErrorHandler section when there was an error. Did I do something wrong? Please help. Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please help with On Error GoTo
JLGWhiz,
Thanks for the code. I will try it tomorrow. One thing I do not understand is I use the same code on one of my macro, and it works perfectly. Now when I tried to use it on this one, it does not work. Thanks. "JLGWhiz" wrote: One way: ErrorHandler: If Err.Number 0 Then Msgbox "An error has occurred please contact the IT department", vbCritical End If If there is no error is will skip the message box. "Accesshelp" wrote in message ... Hello all, In my code, I inserted an error trapping code in case an error has occurred. If there is an error, the code will jump to the error handler section and execute the code in the ErrorHandler section. So the following is what I have: On Error Goto ErrorHandler 'The code in between ErrorHandler: Msgbox "An error has occurred please contact the IT department", vbCritical Somehow, the code from above executes the code in the ErrorHandler: section even there is no error. The code however did jump right into the ErrorHandler section when there was an error. Did I do something wrong? Please help. Thanks. . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please help with On Error GoTo
Depending on whether your code is a subroutine or function, you can put
either this line of code... Exit Sub or this line of code... Exit Function immediately in front of your ErrorHandler label line to prevent your regular code from falling through into your error handling code. -- Rick (MVP - Excel) "Accesshelp" wrote in message ... Hello all, In my code, I inserted an error trapping code in case an error has occurred. If there is an error, the code will jump to the error handler section and execute the code in the ErrorHandler section. So the following is what I have: On Error Goto ErrorHandler 'The code in between ErrorHandler: Msgbox "An error has occurred please contact the IT department", vbCritical Somehow, the code from above executes the code in the ErrorHandler: section even there is no error. The code however did jump right into the ErrorHandler section when there was an error. Did I do something wrong? Please help. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Resetting error reporting after On Error GoTo | Excel Programming | |||
On Error Goto 0 | Excel Programming | |||
Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
On Error Goto doesn't goto | Excel Programming | |||
On Error Goto doesn't goto | Excel Programming |