Using Design-Time Tools
The Visual Basic Editor design-time error-handling tools let you correct mistakes in VBA syntax and catch misspellings of variable names. They also let you follow the “flow” of a macro or function (seeing each line of code as it is executed) and monitor the values of variables during the course of a procedure’s execution.
Catching Syntax Errors
If you type a worksheet formula incorrectly in Excel, Excel alerts you to the error and refuses to accept the entry. The VBA compiler (the system component that converts your English-like VBA code into the machine language that actually executes the macro on your computer) ordinarily performs the same service for you if you type a VBA expression incorrectly. If you omit a required ...
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.
