View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default 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.
.