VBATrain.com
Chapter 1 The Visual Basic Editor Page 3 of 11

   VBATrain Home    |    Sample Lessons Index    |   Previous Page    |   Next Page


Project Explorer Window

The Project Explorer shows a tree view of all the objects in the current instance of Excel. In our case, it shows the new workbook we have open and the objects associated with it.

Note that, in most cases, there are two ways each object is identified.  For example, the first sheet has both an object name of "Sheet1" and a sheet name of Sheet1. The name in parenthesis is the name of the sheet as you see it on a sheet tab in the workbook. The first "Sheet 1", the name that is not in parenthesis, is the object name of the worksheet. You can use this object name in VBA code to refer directly to the worksheet. We will work more with this later.


Project pane, VB Editor





   VBATrain Home    |    Sample Lessons Index    |   Previous Page    |   Next Page

Click here for feedback and questions about this chapter.

Copyright © 2006-2008 J. Donald McClenagan, PhD, ALL RIGHTS RESERVED