Introduction to Excel VBA and Basic Features

How to Create a Macro in Excel

VBA stands for Visual Basic for Applications. VBA enables you to automate different activities in Excel like generating reports, preparing charts & graphs, doing calculations, etc. This automation activity is also often called as Macro. it supports for users to save their time spent behind running the repetitive steps.

Accessing VBA Editor

If you are using Excel version 2007 (or a higher version), click on File > Options > Customize the Ribbon and then check “Developer" and click ok.

A new tab will be added :

Now you can access the Visual Basic Editor in the Developer Ribbon:

In Visual Basic Editor, you will find the Project Window. This window contains number of the “modules” for all workbooks. Modules are where the code is stored. 

To insert a module in sheet and go to the Insert Menu (ALT > I).

You can rename Modules in the Properties Window. Renaming modules make it easier and helpful to organize your code. If your VBA project contains more than one module then you should rename the modules.