the execution of the code Watch Window Monitor values of specified variables and expressions while the code is running Immediate Window Test your output by assigning different values to variables or expressions Locals Window Monitor all the declared variables of the procedure currently running Exercise 55 Debugging Break mode and Breakpoint Whenever a run time is detected in VBA the execution of the program pauses and the program enters what’s called break mode. At this point in time the line of code causing the problem is displayed and highlighted in yellow, this helps you trace and debug the error. When you’re in break mode you can examine also the variables and properties by pointing to them. set You can your own breakpoint in the code to pause at a specific place, when the executed code reaches the breakpoint VBA switches into break mode. Breakpoints are temporary markers and are not saved along with the code. To insert or remove a breakpoint place the insertion point in the code you want to insert the break point and use one of the following methods. Choose debug, toggle breakpoint Press F9 Click the toggle breakpoint button on the debug toolbar ( if not open then, view, toolbars, debug.
the execution of the code Watch Window Monitor values of specified variables and expressions while the code is running Immediate Window Test your output by assigning different values to variables or expressions Locals Window Monitor all the declared variables of the procedure currently running Exercise 55 Debugging Break mode and Breakpoint Whenever a run time is detected in VBA the execution of the program pauses and the program enters what’s called break mode. At this point in time the line of code causing the problem is displayed and highlighted in yellow, this helps you trace and debug the error. When you’re in break mode you can examine also the variables and properties by pointing to them. You can set your own breakpoint in the code to pause at a specific place, when the executed code reaches the breakpoint VBA switches into break mode. Breakpoints are temporary markers and are not saved along with the code. To insert or remove a breakpoint place the insertion point in the code you want to insert the break point and use one of the following methods. Choose debug, toggle breakpoint Press F9 Click the toggle breakpoint button on the debug toolbar ( if not open then, view, toolbars, debug.
Excel%20VBA%20Course%20Exercises%2014-3-13.docx