How to Create Macro in VBA Editor

How to run a Macro from Excel Ribbon (Developer Tab)

If the user and creator of the macros are the same, then instead of spending time creating buttons and shapes, we can directly run the macro from the VB Editor.

Step 1: Go to the Developer Tab on the Ribbon

Step 2: Click on the Visual Basic

In the Code Group, click on Visual Basic and a new window would be opened.

Step 3: Click on Run Macro

Then click on the Run Macro sign, it will open a dialog box listing all the macros of that workbook.

Step 4: Select the Macro from the list

Select the macro you want to run from the list and click Run.

As soon as Run is clicked, the macro would be executed on the excel-sheet. If you can only see the VB Editor window and not the sheet, then you may not see the changes happening in the worksheet. To see the changes, minimize/close the VB Editor window. You can also edit a macro as per your need.

Macros In Excel With Example

In Microsoft Excel, where spreadsheets are the playground, we often encounter the repetitious demands of certain tasks. These are the tasks that seem to crop up again and again, capturing our attention with relentless persistence. However, in this age of technological progress, a silent hero steps forward to liberate us from this ceaseless cycle – the unassuming yet powerful “Macro.” Think of macros as Excel’s covert operatives for automation, working quietly in the background to spare us the laborious duty of manually carrying out repetitive tasks. They are the unsung champions of efficiency, gifting us the remarkable ability to accomplish in mere moments what would otherwise devour hours of our valuable time. But what exactly is a macro? At its essence, a macro is a sequence of actions carefully recorded by Excel, patiently waiting for our directive to execute a specific task. Picture this: every mouse click and keystroke, discreetly tucked away within the confines of a macro, poised to spring into action at our command, ready to perform its enchantment.