What You Can Do with VBA

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide.

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.

Happy Excelling 🙂

Hello! Welcome to my Excel blog! I am conducting deep dives into the world of Excel. Please join with me and explore Excel deeply. Keep in mind this African proverb: "If you want to go fast, go alone, If you want to go far, go together." Let's together explore Excel deeply! ☕

  1. Reply
    Zabi August 27, 2018 at 8:33 PM

    Can you please provide me complete VBA videos?

    Leave a reply