The Visual Basic Editor in Excel 2007:-

From Excel, you press Alt+F11 or, from the Developer ribbon, you choose Code, Visual Basic to open the Visual Basic Editor. The VBA Editor, shown in the Figure (specified below), has three main sections:

1. Project Explorer—this pane displays a hierarchical tree of all open workbooks. You can expand the tree to see the worksheets and code modules present in the workbook. If the Project Explorer is not visible, you can enable it by pressing Ctrl+R.

2. Properties window—The Properties window is important when you begin to program user forms. It is also useful when you’re writing normal code. You enable it by pressing F4.

3. Code window—this is the area where you write your code. Code is stored in one or more code modules attached to the workbook. To add a code module to a workbook, you select Insert, Code Module from the application menu.



(The Visual Basic Editor window is lurking behind every copy of Excel shipped since 1993.)