What You Can Do with VBA

VBA is a very rich programming language. It has thousands of uses. A few things are listed below that you can do with VBA macros.

Insert boilerplate text. Sometimes you may need to enter standard text into a range of cells. You can create a macro to do the typing for you. Click here to know about the boilerplate text.
Automate a procedure that you do frequently in Excel. For example, you may need to prepare a month-end sales report. If the task is straightforward, you can develop a macro to do it for you.
Automate repetitive operations. If you need to perform the same action in different workbooks, you can record a macro when you are performing the task in your first workbook. Then you can let the macro repeat your action in the other workbooks.
Create a custom command. For example, you can combine several Excel commands so
that they’re executed from a single keystroke or from a single mouse click.
You can create a simplified “front end” for users who don’t know much about Excel. For example, you can set up a foolproof monthly expense template.
You can develop a new worksheet function. Although Excel has a wide range of built-in functions, you can also create custom functions that greatly simplify your formulas.
Create complete macro-driven applications. You can create custom dialog boxes and add new commands to the Ribbon using Excel Macro.
Create custom add-ins for Excel. Most add-ins we get with Excel were created with Excel macros.