Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Catching an error
I'm trying to implement the try/catch structure that Java
provides in VBA. I want to try a line of code, if it returns an error, I want to be able to catch it and return a message box to the user of my program indicating that they performed an illegal action. I cannot figure out how to do this, if anyone can help me, I would be very appreciative. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Catching an error
At the beginning of said code, write the line:
On Error GoTo ErrorCatcher and include somewhere the label: ErrorCatcher: followed by the code too be executed in teh event of an eror. P.S. It doesn't have to be named "ErrorCatcher." You can use any valid identifier. - Pikus -----Original Message----- I'm trying to implement the try/catch structure that Java provides in VBA. I want to try a line of code, if it returns an error, I want to be able to catch it and return a message box to the user of my program indicating that they performed an illegal action. I cannot figure out how to do this, if anyone can help me, I would be very appreciative. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MACRO: Catching only filled cell data | Excel Discussion (Misc queries) | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
CATCHING DUPLICATE INFORMATION IN DIFFERENT CELLS SAME PROGRAM | Setting up and Configuration of Excel | |||
[how to] VBA catching close/print in printpreview | Excel Programming |