Studies show that good grammar leads to more promotions and higher salaries. Write with Grammarly

Macros in Microsoft Excel

In this post, you’ll learn about Macros, its use case and how to use Macros in your Excel workbook.

What is an Excel Macro?

Excel Macro is a record and playback tool that records your Excel steps and you can playback it as many times. VBA (Visual Basic Applications) Macros saves time. Macros is a programming code that runs in an Excel environment.

Uses of Macros

  • Macros automate repetitive tasks
  • You can use a macro to record the steps of importing the data, formatting it to meet your business reporting requirements.
  • Macros record your steps in excel so you can play it at any time and for countless times.
  • Let’s see an example of a Macro program in Excel.

How to Enable Developer Option in Excel?

To run a macro program, you need to have access to developer option in Excel.

To enable the Developer option,

  • In the main menu “FILE”
  • Select “Options.”
  • In the corresponding window, Click on Customize Ribbon
  • Check the Developer option
How to Enable Developer Option in Excel?
  • Click on OK button

Now, you can see the Developer tab in the ribbon.

Sample program using the macros in Excel

To run a macros code in Excel, follow these steps.

  • Go to Developer options in the ribbon.
  • Under the Code option, click Visual Basic
Sample program using the macros in Excel
  • Enter the following code and click Save.
Sample program using the macros in Excel

Run the Macros in Excel

  • Go to Developer options in the ribbon.
  • Under the Code option, click Macros.
Run the Macros in Excel
  • Select your Macro and Click Run.
Run the Macros in Excel
  • Type in your custom footer, click OK.
  • Now you should be able to see your text on your footer.

Visual Basic Editor

Microsoft Visual Basic for Applications (VBA) enables non-programmers to record, create, and edit macros that can automate tasks in Office applications. Excel’s Visual Basic for Applications editor is a tool that enables you to write and edit custom scripts that automate actions in Excel.

Writing a macro from the VBA editor is more flexible than recording a macro.