CHAPTER 10 - EXCEL VBA DEBUGGING

10.1 Excel VBA Debugging

Use the following tips to debug a program.

• Your program should consist of many functions and subroutines. Do not use one monolithic program.
• Test small portions of your program at a time to be sure everything works.
• Use many message boxes to print out the value of variables in the program. You can always comment them out later with a single quote.
• If you are testing a function, call it from a simple subroutine.
• If you are testing a subroutine with arguments, you must call it from the parent subroutine.
• If you enter code and it appears in red, you have an error.
• Click on the window after entering new code to activate the editor window.

If you really get stuck, set a breakpoint in the subroutine and step through your code. To set the breakpoint, move the cursor to a statement for a start point. Then choose Debug -> Toggle Breakpoint. Press F8 to step through your program. To exit Debug choose Debug -> Clear All Breakpoints. Then choose Run -> Reset.

theSurfDragon.com

Excel Navigation

Table of Contents
Ch1-Introduction
Ch2-Loops
Ch3-If Statements
Ch4-Functions
Ch5-Subs & Functions
Ch6-Read & Write
Ch7-Operators
Ch8-Built-in Functions
Ch9-Built-in Examples
Ch10-Debugging
Ch11-Running Subs
Ch12-Sample Programs
Ch13-WS Formulas
Ch14-Questions