Whats Next

In this chapter you learned how to test your VBA procedures to make sure they perform as planned. You debugged your code by stepping through it using breakpoints and watches. You learned how to work with the Immediate window in break mode. You found out how the Locals window can help you monitor the values of variables and how the Call Stack dialog box can be helpful in keeping track of where you are in a complex program. You've learned to specify parts of your procedure that you want to include or exclude upon compilation. Finally, you learned how to trap errors with error-handling routines. By using the built-in debugging tools, you can quickly pinpoint the problem spots in your procedures. Try to spend more time getting acquainted with these tools. Mastering the art of debugging can save you hours of trial and error.

By completing Chapters 1 through 13, you have gained a solid, working knowledge of the Visual Basic for Applications language that you're most likely to need to get started in your own Excel spreadsheet automating projects. This chapter ends the intermediate level of your encounters with VBA in Excel 2002. VBA offers many more advanced features, which we will explore in the remaining chapters of this book.

0 0

Post a comment