The Menu bar and toolbar are positioned at the top of the window. All code windows look the same (except for the written code), so the Title bar displays the source of this code. This shows the VBA code for an existing macro that is currently open.

The majority of the VBA editor window is taken up by the Code window. The following image shows how the VBA editor typically looks when opened for the first time. Both windows are open, and if you were to close the VBE, you would be returned to the Excel workbook. The VBA editor window opens on top of the Excel window. Then check the Developer box in the list on the right of the window to show the tab on the Ribbon.ĭifferent elements of the Visual Basic editor window If you do not see the Developer tab on the Ribbon in Excel, then click File > Options > Customize Ribbon. To open the Visual Basic editor, click Developer > Visual Basic or press Alt + F11 as shown in the following image. Before we go any further in this introduction to VBA in Excel series, we need to know how to open VBA in Excel, or more specifically, how to open the VBA editor.

Learn visual basic for excel free