VBA Local Window and Watch Window
In VBA when you run the code, you are not able to see how the code works and the results produced by each step.
The Local window enables you to see the value of every variable and each member of the objects which are in the current code means the Local window helps you to see the value of every variable.
Watch window enables you to monitor the value of a certain variable.
To enable the Local window, click on this button located on the Debug toolbar.
To enable the Watch window, click on this button located on the Debug toolbar.
Related: Excel VBA common basic questions
Related: How to Record, Run and Save Macro
Related: VBA Data Types of Variables
Written by: Kalpesh Agrawal (Actuarial Intern- IIB)