Chapter 11: Handling Errors
Try as you may, mistakes will be made. After all, we're only human. There are three types of errors in the VBA world of coding; syntax errors, compile errors, and runtime errors. Even experienced programmers encounter these problems to some extent. In the world of programming, errors are part of the territory, so consider yourself in good company.
The sooner you learn how to deal with all types of errors, the easier your life as a programmer will be.
In this chapter, we will cover the following recipes:
- Handling different types of errors
- Correcting a runtime error
- Testing to find errors
- Using the
On Errorstatement - Resuming after an error
By the end of this chapter, you will be able to do error handling in VBA.
