FLASH SALE! - "CHATGPT AND ARTIFICIAL INTELLIGENCE FOR MICROSOFT EXCEL AT 60% OFF" Enroll Now

VBA Editor

Updated on June 6, 2024
Article byJeevan A Y
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

Excel VBA Editor

VBA Editor is the platform to write and edit the VBA code. By default, it is hidden. To use it, we need to activate it. Visual Basic Editor (VBE) is a separate application for Microsoft products like Excel, Word, and PowerPoint.

VBA-Editor

You are free to use this image on your website, templates, etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: VBA Editor (wallstreetmojo.com)

How to Open Visual Basic Editor?

We can open VBE using three different ways.

#1 – Using Developer Tab

To open the Editor, we must go to the Developer tab of excel and click on the “Visual Basic” option, as shown in the picture below.

Using Developer Tab

#2 – Using Worksheet Tab

We can also open the Editor by using the Worksheet tab as well. To open this in the worksheet tab, right-click on select View Code.

Using Worksheet Tab

 #3 – Using Shortcut Key

Of all the three ways, this is the favorite. We do not use the other two methods at all. press, the shortcut excels key ALT + F11 To open the Editor window.

It is a toggle shortcut when you press it. If you press it again, it will take you back to the active workbook.

Using Shortcut Key

–>> If you want to learn Excel VBA professionally, then our VBA Basic Course (16+ hours) is the perfect solution. In our Basic Excel VBA course you learn the skill of automating tasks using Variables, Data Types, Ranges, and Cells in VBA. Master Control Structures, including Conditional Statements and Loops, and discover techniques for manipulating data through sorting, filtering, and formatting. By the end of the course, you will be able to apply your acquired skills to real projects, culminating in an Excel VBA project which will solidify your ability to create efficient, automated solutions.

Visual Basic Editor Window

If you look at the VBA window for the first time, it does not look very comforting 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 Editor still has its retro look from the beginning.

We usually see four parts in the Visual Basic Editor window. Below is a detailed explanation of the same.

  • Menu Bar: Like Excel has a menu ribbon; similarly, Visual Basic Editor has its menu bar. It has all the available things in VBA. You can do settings, insert modules, toolbars, etc.
visual basic editor in excel VBE step 1
  • Tool Bar: In the toolbar section, we can save, head back to the Excel worksheet, we can redo, undo, run the macro, stop the macro, etc.
VBA Editor step 2
  • Project Window: It is always on the left side of the Editor. It has a workbook name, worksheet name, and modules.
visual basic editor in excel VBE step 3
  • Properties Window: Properties window is associated with the Project window. Here, we can change the sheet name, module name, etc. Suppose you do not see this window by default; press F4 to activate it.
visual basic editor in excel VBE step 4

It is a floating window. We can move anywhere within the window. Using this window, we can change the selected object’s properties.

How to use VBA Editor?

Example #1 – Adding Modules in Editor

We write all the macro codes inside the module. By default, you do not get to see the module. So first, we need to insert the module.

Go to Insert > Module.

VBA Editor step 5

As soon as you click on “Module,” you can see the newly created module under the worksheet project tool.

visual basic editor in excel VBE step 6

As soon as you insert the module, you can see the white blank window on the right-hand side, called the “Code” window. In this window, we write all the codes.

It is the basic and much-needed introduction to the Visual Basic Editor (VBE).

Note: If you do not see all the options at first go, there is nothing to panic about here because you can enable and disable it at any time under the “View” menu.

Example #2 – Working with Properties Window

One simple introduction you need here is how to work with the “Properties” window. Using this window, we can change the properties of the objects here.

For example, if you want to change the worksheet’s name, you can change it here.

visual basic editor in excel VBE (Properties window)

Similarly, you can change the module name as well.

Properties window module

It is the general overview of the Visual Basic Editor window. The more you use it, you will slowly get to know the window.

This article has been a guide for the VBA Editor. Here, we learn how to open the Excel VBA Editor and use it, including the menu bar, toolbar, project, and properties window with descriptions. You may learn more about Excel VBA from the following articles: –