totn Excel 2010 VBA Environment

MS Excel 2010: Watch Window in VBA Environment

This Excel tutorial explains the Watch Window in the VBA environment in Excel 2010 (with screenshots and step-by-step instructions).

Watch Window

The Microsoft Visual Basic for Applications window displays your VBA environment in Excel 2010:

Microsoft Excel

Next, let's analyze the Watch window in the VBA environment.

Microsoft Excel

In Excel 2010, the Watch window is usually found below the Code window. It is one of the most valuable tools when debugging in the VBA environment. It lets you:

  • Define and monitor any expression.
  • When in debug mode, it lets you view the value of the watched expression in its current state. This will be discussed in the tutorial on Debugging VBA Code.

If the Watch window is not visible when you open the Microsoft Visual Basic for Applications window, you can make it visible by selecting Watch Window under the View menu.

Microsoft Excel

Share on: