Locals Window Using VB Editor to Write a Code Module Code Window Vs Object Code Window 2. Table of Content Close KEY POINTS What is the Visual Basic Editor Open the Visual Basic Editor From the developer tab Shortcut Key (Window) Edit a Macro from the List On Quick Access Toolbar From the Worksheet Tab Components of Visual Basic Editor 1. It has multiple tools to help you to write and manage all the codes. It also stores the macros that you recode with the macro recorder. You need to have the developer tab on the ribbon to access it. You can add the object or reference libraries with the help of adding VBA references.ģ.Its a separate application but you can only use it with Excel.

Module: All created macros will be available under this modules folder Forms: Any user forms created in the excl VBA will be available under this folderģ. Microsoft Excel Objects: All Excel Sheets and workbooks will be available under this folderĢ. On the left side of the window under project explorer, you will find 3 folders:ġ. We feel that this is the best configuration of the Visual Basic Editor. To cover the whole screen, you can maximize the Code Window. The Code window can be added by clicking on one of the sheet names. Click on Project – VBAProject and drag the Project Explorer to the left side of the screen If not, follow the below steps to achieve this:ģ. Most probably the Project Explorer will already appear as a column on the left side of the screen. If you can’t see the Project Explorer, click on View and then Project Explorer. The left window with the sheet names in it is called the Project Explorer. To launch the Visual Basic Editor in Excel 2010 or Excel 2007, click on Visual Basic (or press Alt+F11).īelow Visual Basic Editor window will open The Visual Basic Editor is the starting point for creating macros in Excel VBA, so it is important to get this configuration right.

Open visual basic editor excel 2016