Wednesday, December 8, 2010

The Project Window in the Visual Basic Editor of Excel

As you can see, the Project window shows you all the workbooks that are open ("Book1") in the example below) and their components. You can use the + and - signs to show the details.

A new Excel workbook includes three sheets and another component named "ThisWorkbook" is a component in which you will store the macros ( also called VBA procedures) that should start automatically when the workbook is opened.

We will now complete a brief exercise to learn how easy it is to work within the Project Window.

No comments: