totn Excel 2011 VBA Environment

MS Excel 2011 for Mac: Properties Window in VBA Environment

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

Properties Window

The Visual Basic editor displays your VBA environment in Excel 2011:

Microsoft Excel

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

In Excel 2011 for Mac, the Properties window can be accessed from the Visual Basic editor. It displays the properties for the object currently highlighted in the Project Explorer.

Microsoft Excel

In the example above, it is displaying the properties for the module called Module1.

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

Microsoft Excel