Catching an error

  • Thread starter Thread starter Shannon
  • Start date Start date
S

Shannon

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.
 
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
 
Back
Top