Introduction

VBA is stands for Visual Basic for Applications. It works with the Microsoft office applications like – Excel, Word, PowerPoint etc.

Here we will learn VBA with MS Excel. We can automate are daily work, which we do in excel.

We can write our code in Visual Basic Editor. To open a Visual Basic Editor, we need to enable Developer tab first.

How to enable a developer tab in Excel?

Go to the File>>Options>>Customize Ribbon>>Check the Developer option.

Enable Developer Tab in Excel
Enable Developer Tab in Excel

You also can watch below given video to learn how enable the developer tab.

Visual Basic Editor is available in left side.

Visual basic Editor option
Visual basic Editor option

Click on Visual Basic or Press Alt+F11 short cut key to open a Visual Basic Editor.

Visual Basic Editor Window looks like below image.

Visual Basic Editor
Visual Basic Editor

Now we will learn in next chapters how to write code in Visual Basic Window

Watch the step-by-step video tutorial:


 

Next Chapter>>Macro Recording