REAL-TIME

VBA Projects

Full Access with Source Code
  • Designed and Developed by PNRao

  • Full Access with VBA Source Code

  • Well Commented Codes Lines

  • Creative and Professional Design

Effortlessly
Manage Your Projects

120+ Project Management Templates

Seamlessly manage your projects with our powerful & multi-purpose templates for project management.

120+ PM Templates Includes:
  • 50+ Excel Templates

  • 50+ PowerPoint Templates

  • 25+ Word Templates

Share Post

We can execute a macro in many different ways, in this topic we will learn Running macro in Excel: From Macro Dialog and By assigning a short-cut key to the Macro

Running Macro in Excel: Executing or From Macro Dialog

Follow the below steps to assign a macro to a shortcut key:

Step 1: Go to Developer Tab or View Tab
Step 2: Select Macros from the Developer Tab or View Tab

It will open the Macro Dialog.

Step 3: Select a Macro which you want to execute it
Step 4: Click on Run” button

It will execute the selected macro.

Running Macro in Excel

Running Macro in Excel: Executing By Assigning a Shortcut Key to the Macro

Follow the below steps to assign a shortcut key to the macro:

Step 1: Go to Developer Tab or View Tab
Step 2: Select Macros from the Developer Tab or View Tab

It will open the Macro Dialog.

Step 3: Select a Macro which you want to assign a shortcut key
Step 4: Click on “Options…” button

It will show you Macro Options Dialog.

Step 5:Enter an alphabet in the Shortcut key text box

Example if you enter ‘q’, you have press Ctrl+q to execute your macro

Step 6:Then Press OK and Close the Macro Dialog

You are done! you can execute by pressing shortcut key (in this example it is Ctrl+q)

See the below image to understand the above steps:
macro-assign-shortcut-key

We have many other options to execute a macro, we will see it in the advanced tutorials.

Effortlessly Manage Your Projects and Resources
120+ Professional Project Management Templates!

A Powerful & Multi-purpose Templates for project management. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.

Save Up to 85% LIMITED TIME OFFER
Project Management Templates

All-in-One Pack
120+ Project Management Templates

Essential Pack
50+ PM Templates

Excel Pack
50+ Excel PM Templates

PowerPoint Pack
50+ Excel PM Templates

MS Word Pack
25+ Word PM Templates

Ultimate Project
Management Template
Ultimate Resource
Management Template
Project Portfolio
Management Templates
Categories: Excel VBATags: Last Updated: June 17, 2022

Leave A Comment