O'Reilly logo

Mastering VBA for Microsoft® Office 2010 by Richard Mansfield

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 17. Debugging Your Code and Handling Errors

In this chapter, you'll learn some of the things that can go wrong in your VBA code and what you can do about them. You'll examine the types of errors that can occur, from simple typos to infinite loops to errors that occur only once in a while (they can be the hardest to figure out). The chapter starts by explaining the principles of debugging. Then you'll work with the tools that VBA offers for debugging VBA code and use them to get the bugs out of a few statements. The end of the chapter discusses the various methods of handling errors and when to use each one.

In this chapter you will learn to do the following:

  • Understand the basic principles of debugging

  • Recognize the four different types of ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required