Search
  • Kalpesh Agrawal

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: How to add VBA to the Excel and common terms of
Related: VBA Data Types of Variables

Written by: Kalpesh Agrawal (Actuarial Intern- IIB)



0 comments

Related Posts

See All