What You Can be done with VBA

1. 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.
2. 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.
3. 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.
4. 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.
5. 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.
6. 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.
7. Create complete macro-driven applications. You can create custom dialog boxes and add new commands to the Ribbon using Excel Macro.
8. Create custom add-ins for Excel. Most add-ins we get with Excel were created with Excel macros.