Chapter 9Debugging VBA Procedures and Handling Errors
In the course of writing or editing VBA procedures, no matter how careful you are, you’re likely to make some mistakes. For example, you may misspell a word, misplace a comma or quotation mark, or forget a period or ending parenthesis. These kinds of mistakes are known as syntax errors. Fortunately, Visual Basic is quite helpful in spotting these kinds of errors. To have Visual Basic automatically check for correct syntax after you enter a line of code, choose Tools | Options in the Visual Basic window. Make sure the Auto Syntax Check setting is selected on the Editor tab.
Figure 9-1: The ...
Get Access 2007 Programming by Example with VBA, XML, and ASP 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.
