Error Handling in Excel VBA

The main purpose of is to help you handle errors in VBA.

As you learn in :

• Errors may happen.
• One of your (main) objectives when programming is to avoid errors.
• In practice, VBA users of all levels (from beginner to advanced) must (from time to time) deal with errors.
• You (generally) do not want errors to occur when a user executes a procedure.

Because of the above:

• Error handling is an essential skill for (virtually) any VBA Developer (like you).
• You are likely to often deal with (and handle) errors.

:

• Is part of my Book Series; and
  
• Assumes you know about the topics covered in: (i) My previous Book Series, particularly the Book Series; and (ii) The previous Books in the Book Series, particularly .
  

is divided into four Chapters.

• Chapter 1 is an introduction to errors in VBA.
• Chapter 2 is an introduction to error handling in VBA.
• In Chapter 3, you learn: (i) About error trapping settings; and (ii) How to specify the appropriate error trapping settings to handle errors.
• In Chapter 4, you learn how to work with the basic error handling construct in Excel VBA: The On Error statement.