There are a lot of pieces of information that I would suggest someone taking the course to go through the videos more than once.

Would recommend to anyone wanting to learn and master Excel.

Study Time 2h 12m Video Duration data-triggerhover data-template data-placementauto right.

Study Time 4h 19m Video Duration data-triggerhover data-template data-placementauto right.

Study Time 3h 12m Video Duration data-triggerhover data-template data-placementauto right.

Study Time 2h 11m Video Duration data-triggerhover data-template data-placementauto right.

It is similar to the Excel ribbon where you have tabs and options with each tab.

In this tutorial, I will cover all there is to know about the VBA Editor and some useful options that you should know when coding in Excel VBA.

This Tutorial Covers: What is Visual Basic Editor in Excel Opening the VB Editor Keyboard Shortcut to Open the Visual Basic Editor Using the Developer Tab Using the Worksheet Tab Anatomy of the Visual Basic Editor in Excel Menu Bar Tool Bar Project Explorer Properties Window Code Window Immediate Window Where to Add Code in the VB Editor Module Code Window Vs Object Code Window Adding VBA Code in Module Adding Code to the Object Code Window Customizing the VB Editor Editor Tab Auto Indent Editor Format Tab General Tab What is Visual Basic Editor in Excel Visual Basic Editor is a separate application that is a part of Excel and opens whenever you open an Excel workbook.

By default, its hidden and to access it, you need to activate it.

Basics Excel 2017 Code In The

There are multiple ways you get the code in the VB Editor: When you record a macro, it automatically creates a new module in the VB Editor and inserts the code in that module.

You can copy a code from some other workbook or from the internet and paste it in the VB Editor.

Opening the VB Editor There are various ways to open the Visual Basic Editor in Excel: Using a Keyboard Shortcut (easiest and fastest) Using the Developer Tab.

Keyboard Shortcut to Open the Visual Basic Editor The easiest way to open the Visual Basic editor is to use the keyboard shortcut ALT F11 (hold the ALT key and press the F11 key).

As soon as you do this, it will open a separate window for the Visual Basic editor.

This shortcut works as a toggle, so when you use it again, it will take you back to the Excel application (without closing the VB Editor).

Basics Excel 2017 How To Get It

The shortcut for the Mac version is Opt F11 or Fn Opt F11 Using the Developer Tab To open the Visual Basic Editor from the ribbon: Click the Developer tab (if you dont see a developer tab, read this on how to get it).

Using the Worksheet Tab This is a less used method to open the Vb Editor.

Go to any of the worksheet tabs, right-click, and select View Code.

This method wouldnt just open the VB Editor, it will also take you to the code window for that worksheet object.

This is useful when you want to write code that works only for a specific worksheet.

Anatomy of the Visual Basic Editor in Excel When you open the VB Editor for the first time, it may look a bit overwhelming.

There are different options and sections that may seem completely new at first.

While Excel has improved tremendously in design and usability over the years, the VB Editor has not seen any change in the way it looks.

In this section, I will take you through the different parts of the Visual Basic Editor application.

Note: When I started using VBA years ago, I was quite overwhelmed with all these new options and windows.

But as you get used to working with VBA, you would get comfortable with most of these.

And most of the time, youll not be required to use all the options, only a hand full.

Below is an image of the different components of the VB Editor.

These are then described in detail in the below sections of this tutorial.

Basics Excel 2017 For Mac