VBA Error Handling PT2

In this VBA Error Handling set I’ll talk about using the error object

Here is a chart referencing the Error object’s properties for you to reference:

Property Description

The number of the error.

Description The description of the error.
Source The name of the object or application that originally generated the error.


“APP_NAME” is a constant I declared in the General Declarations section of the module. You may want to put all these declarations in a module by themselves.

<< VBA Error Handling PT1 | VBA Do Loop >>

Free! Subscribe To Our YouTube Channel!

facebooktwittergoogle_plusredditpinterestlinkedinmailby feather
Tags: , ,


Call Erik Now