In Excel, you can automate tasks by using macros. A macro is a set of instructions that tells Excel what to do. These commands are written in a computer programming language called VBA. VBA is a short form of Visual Basic for Applications. It is a Powerful Programming Language with rich features. Following are the list of few things that you can do with VBA.

Automate Repetitive Task: If Excel is something you use as a part of your work activities, then surely you must be doing similar tasks again and again. To avoid repetition and save your time, you can use VBA Macros to do that work for you.

Create Custom Commands: Lets say you have to format a report in some specified Font and Color. You waste lot of time in applying those formatting, instead just create a VBA Macro to apply those formatting and create a Keyboard shortcut for it.

New Worksheet Function: Excel Comes with plenty of functions you can also create a custom function as per your needs.

No Errors: By eliminating Manual effort, Excel VBA Macros will produce accurate results.

User Forms with Controls: Create User Forms to add more interactivity to your Excel Applications. Add Text Boxes, Drop Down Menus, Radio buttons and more control as your needs.

Version 5 of Excel introduced a powerful new macro language called Visual Basic for Application (VBA). Every copy of Excel shipped since 1993 has had a copy of the powerful VBA language hiding behind the worksheets.