excel open microsoft visual basic for applications window.

Above image shows the various options present on the standard toolbar.Ģ. Clicking the menu label brings up the corresponding menu.īelow the Menu Bar, there is a standard toolbar that holds the most frequently used commands in VBE. Menu Bar contains menus to access most functions of the VBE. Menu Bar: This the first and one of the most important part that you see in the Visual Basic Editor. VBE can be divided into 5 basic parts (represented by the numbers), below is the description about them:ġ. When you open VBE using any of the methods mentioned above, you will typically see a window that is more or less like the one in below image. And now to open VB Editor, simply navigate to Developer Tab in the ribbon and click the Visual basic button as shown. To display Developer tab in Excel 2007 or later version simply navigate to File > Options > Customize Ribbon, check the ‘Developer’ checkbox and click ‘Ok’.Īfter this, your Developer Tab will become visible. So, first you need to un-hide the developer tab and then open the VB Editor.

But generally, Developer tab is hidden by default in Excel. Access VBE from Ribbon in Excel 2007 and Later Versions: Visual Basic Editor in Excel 2007 or later Versions can be opened from ‘Developer’ Tab. Access VBE from Menu in Excel 2003: To open VBE in Excel 2003, navigate to Tools > Macro > Visual Basic Editor. Using Shortcut Key to open VBE : Open your spreadsheet and then simply press ALT + F11 key while in the main/normal Excel window, to open the Visual Basic Editor.Ģ. Opening and accessing VBE is very simple, there are various ways to do it and below I am going to show you top three ways to do it:ġ. So, do not confuse between these terms as they are more or less same. NOTE: Many people also refer VBE as Excel IDE, IDE stands for integrated development environment. VB Editor (or more commonly known as VBE) is the tool used to create, modify and maintain Visual Basic for Applications (VBA) procedures and modules in Excel. Now, after having learned what Excel VBA is, let’s move a bit further and see what is VB Editor.

Excel open microsoft visual basic for applications window.