Conclusion
Excellent debugging skills are one of the primary attributes that separate the professional programmer from the skilled amateur. In this chapter we have covered the vast array of debugging tools and techniques that you have at your disposal in the VBA environment. If ever there were an aspect of programming to which the old adage "practice makes perfect" applies, it is surely debugging. All the dedicated debugging tools described here notwithstanding, the practice of debugging is just as much art as science.
Learning these tools is a starting point, but you must debug a significant amount of real-world code, ideally not all of it your own, before you become truly proficient. Many people have remarked to us, and we believe it to be true, that you learn more from debugging mistakes than you do from getting it right the first time. So go forth and debug!
|