WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Learn VBA » VBA Editor

VBA Editor

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.

VBA Editor

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 excel and click on Visual Basic Option, as shown in the below picture.

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 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.

Using Shortcut Key

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.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

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.

visual basic editor in excel VBE step 1

  • Tool Bar: In the toolbar section, we can save, we can 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 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.

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 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.

VBA Editor step 5

As soon as you click on Module, you can see the newly created module just 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, 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).

Note: If you don’t see all the options at first go, nothing to panic here because you can enable and disable it at any point in time under the View menu.

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.

visual basic editor in excel VBE (Properties window)

Similarly, you can change the module name as well.

Properties window module

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

Recommended Articles

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 –

  • VBA Update Screen
  • VBA UserForm
  • VBA Block Comment
  • VBA JOIN
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More