Chapter 29. Debugging Macros and Custom Functions

Using Design-Time Tools

Dealing with Run-Time Errors

IF you made it through the previous two chapters, you now have at least a smattering of Microsoft Visual Basic for Applications (VBA) at your command—as well as, we hope, an appetite for learning more. The best ways to acquire more expertise in this versatile programming language are to read a book on the subject, such as Microsoft Visual Basic 2008 Step by Step by Michael Halvorson (Microsoft Press, 2008), and to experiment. As you do your everyday work in Microsoft Excel 2010, look for chores that are ripe for automating. When you come across something macro-worthy, record your actions. Then inspect the code generated by the macro recorder. Be ...

Get Microsoft® Excel® 2010 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.