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.
0 kommentar(er)
