totn Excel 2007 VBA Environment

MS Excel 2007: Project Explorer in VBA Environment

This Excel tutorial explains the Project Explorer within the VBA environment in Excel 2007 (with screenshots and step-by-step instructions).

Project Explorer

The Microsoft Visual Basic window displays your VBA environment in Excel 2007:

Microsoft Excel

Next, let's take a few moments to analyze the various sections in the Microsoft Visual Basic window.

The Project Explorer can usually be found in the top left portion of the Microsoft Visual Basic window. It is a hierarchical listing of the objects recognized by VBA.

Microsoft Excel

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 Microsoft Visual Basic window, you can make it visible by selecting Project Explorer under the View menu.

Microsoft Excel