Excel VBA Editor
VBA Editor is the platform to write and edit the VBA code and by default, it is hidden and to use it, we need to activate it. Visual Basic Editor (VBE) is a separate application for Microsoft products like Excel, Word, and PowerPoint.
How to Open Visual Basic Editor?
We can open VBE using 3 different ways.
#1 – Using Developer Tab
In order to open the editor, we can go to the Developer tab of excelDeveloper Tab Of ExcelEnabling the developer tab in excel can help the user perform various functions for VBA, Macros and Add-ins like importing and exporting XML, designing forms, etc. This tab is disabled by default on excel; thus, the user needs to enable it first from the options menu. and click on Visual Basic Option, as shown in the below picture.
#2 – Using Worksheet Tab
We can also open the Editor by using the Worksheet tabWorksheet TabWorksheet tabs in excel are rectangular tabs visible on the bottom left of the excel workbook. The active tab shows the active worksheet available to edit. There can be three worksheet tabs opened by default, and we can insert more tabs using the plus button. as well. To open this in the worksheet tab, right-click on select view code.
#3 – Using Shortcut Key
Of all the three ways, this is my favorite one. In fact, I don’t use the other two methods at all. To open the Editor Window press, the shortcut excels key ALT + F11.
This is a toggle shortcut when you press it appears, and if you press it again, it will take you back to the active workbook.
Visual Basic Editor Window
If you are looking at the VBA window for the first time, then it looks intimidating because of a completely new option and features you see for the first time. When you look at the window, it has a retro look. Even though various new designs replaced the excel visibility Visual Basic still has its retro look from the beginning.
We usually see 4 parts in the Visual Basic Editor window. Below is a detailed explanation of the same.
- Menu Bar: Like how excel has a menu ribbon similarly, Visual Basic has its own Menu Bar. It has all the available things in VBA. You can do settings, insert modules, toolbars, etc.
- Tool Bar: In the toolbar section, we can save, we can head back to the excel worksheet, we can redoWe Can RedoIn Excel, we have an option named “Undo” that we may use by pressing Ctrl + Z. When we undo an action but subsequently realize it was not a mistake, we can cancel the undo action and return to the original point, using "Redo.", undo, run the macro, stop the macro, etc.
- Project Window: It is always on the left side of the editor. It has a Workbook name, worksheet name, and modules.
- Properties Window: Properties window is associated with Project Window. Here we can change the sheet name, and we can change the module name, etc. if you don’t see this window by default, press F4 to activate it.
It is a floating window. We can move anywhere within the window. Using this window, we can change all the properties of the selected object.
How to use VBA Editor?
Example #1 – Adding Modules in Editor
We write all the macro codes inside the module. By default, you don’t get to see the module. First, we need to insert the module.
Go to Insert > Module.
As soon as you click on Module, you can see the newly created module just under the worksheet Project tool.
As soon as you insert the module, you can see the white blank window on the right-hand side, and it is called “Code Window.” In this window, we write all the codes.
This is the basic and much-needed introduction to the Visual Basic Editor (VBE).
Example #2 – Working with Properties Window
One simple introduction you need here is how to work with “Properties Window.” Using this properties window, we can change the properties of the objects here.
For example, if you want to change the name of the worksheet, you can change it here.
Similarly, you can change the module name as well.
This is the general overview of the Visual Basic Editor window. The more you use it, you will slowly get to know the window.
This has been a guide to VBA Editor. Here we learn how to open excel VBA editor and also how to use it, including Menu Bar, Tool Bar, Project, and Properties window with description. You may learn more about excel VBA from the following articles –