Office® XP Development with VBA

Chapter Twenty. VBA Error Handling

Believe it or not, this may be the most important chapter in the entire book. Errors are hardly a glamorous topic, but it is essential that a developer pay close attention to them in any application he or she writes. Runtime errors can be placed on the list, along with death and taxes, of things you cannot avoid. There may not be much you can do about death and taxes, but there definitely is a lot you can do about errors. Furthermore, there are situations in which errors can become tools you use in your project. This chapter explains ways to minimize the occurrence of errors in your projects, and how to deal with inevitable errors.