Chapter 12. VBA Error Handling

Error handling is one of the most commonly omitted features in Excel applications. This is not an acceptable state of affairs. The last thing you want your users to see is an unvarnished Excel or VBA runtime error. They will most surely not understand what they are seeing and they will often panic, lose faith in your application, or both. A good error handling system will not prevent errors from occurring, but it will make the process much less distressing for your users and much easier for you to diagnose and correct.

All the errors discussed in this chapter are runtime errors. These are errors that occur while your code is executing. The other type of error, the compile-time error, should not be a factor at this ...

Get Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft® Excel and VBA® now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.