Friday, August 5, 2016

Properties Window in VBA Environment

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

Microsoft Excel
Next, let's analyze the Properties window in the VBA environment.
The Properties window is usually found directly below the Project Explorer in Excel 2013. 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 Viewmenu.
Microsoft Excel