MS Excel 2011 for Mac: Project Explorer in VBA Environment
This Excel tutorial explains the Project Explorer within the VBA environment in Excel 2011 for Mac (with screenshots and step-by-step instructions).
See solution in other versions of Excel:
Project Explorer
The Visual Basic editor displays your VBA environment in Excel 2011:
Next, let's take a few moments to analyze the various sections in the Visual Basic editor.
In Excel 2011 for Mac, the Project Explorer is a window that can be accessed from the Visual Basic editor. It is a hierarchical listing of the objects recognized by VBA.
In this example, there are four Excel objects which represent each sheet and workbook in your Excel file - Sheet1, Sheet2, Sheet3, and ThisWorkbook.
There is also one module called Module1. The VBA code in Module1 can used anywhere in your spreadsheet. Whereas, the code within an Excel object is typically only used by that object.
If the Project Explorer is not visible when you open the Visual Basic editor, you can make it visible by selecting Project Explorer under the View menu.
Advertisements