totn Excel 2011 VBA Environment

MS Excel 2011 for Mac: Immediate Window in VBA Environment

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

Immediate Window

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

Microsoft Excel

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

Microsoft Excel

In Excel 2011 for Mac, the Immediate window is an essential element of the debugger found within the VBA environment. It lets you:

  • Type code and press ENTER to view the results of the code.
  • When in debug mode, it lets you view the value of a variable in its current state. This will be discussed in the tutorial on Debugging VBA Code.

If the Immediate window is not visible when you open the Visual Basic editor, you can make it visible by selecting Immediate Window under the View menu.

Microsoft Excel

Share on: