Project Explorer This pane displays a hierarchical tree of all open workbooks. Expand the tree to see the worksheets and code modules present in the workbook. If the Project Explorer is not visible, enable it with Ctrl+R.
Properties window The Properties window is important when you begin to program user forms. It has some use when writing normal code, so enable it with F4.
Code window This is the area where you will write your code. Code is stored in one or more code modules attached to your workbook. To add a code module to a workbook, select Insert, Code Module from the application menu.
1. The Visual Basic Editor window is lurking behind every copy of Excel shipped since 1993.