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.

MS Excel VBA Features

Macro

Macro is one of the most popular features in Excel 2003 and Excel 2016 VBA. Macros in Excel VBA allow you to convert tasks in Excel by writing.

Macros allow users to automatically create customized charts, reports and perform other functions. In addition, Macros automate tasks and merge program functions that enable developers to build customized solutions using Visual Basic.

CHOOSE function

The CHOOSE function is a built-in function in Excel that is classified as a Lookup/Reference Function. It can be used as a worksheet and VBA function in Excel. As a worksheet function, the CHOOSE function can be entered as piece of a formula in a cell of a worksheet. we can also use this function in macro code that is entered through the Microsoft Visual Basic Editor.

Leave a Reply

Your email address will not be published. Required fields are marked *

Our Clients