Running macro in Excel

Home/Excel VBA/Running macro in Excel

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

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


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.

LIMITED TIME OFFER
By |March 23rd, 2013|Excel VBA|0 Comments

About the Author:

PNRao is a passionate business analyst and having close to 10 years of experience in Data Mining, Data Analysis and Application Development. This blog is his passion to learn new skills and share his knowledge to make you expertise in Data Analysis (Excel, VBA, SQL, SAS, Statistical Methods, Market Research Methodologies and Data Analysis Techniques).

Leave A Comment


Related pages


gantt chart excel 2007 templatefor vba stepexcel test interview samplecombining chart types in exceluseful vba codes for excelexcel combo box macrohow to duplicate excel worksheetadvanced ms excel tutorialvba shortcutvba userform textboxvb clear listboxvba writerexcel sheet protection passwordmacros tutorialsexcel formula cell colourremove duplicates vbaaccess vba comboboxproject manager excel templateopen a file in excel vbavb interview questions and answers for experiencedsas tutorial pdf beginnerssave excel file vbaexcel recording macroswhat is row height in excelhow to add pivot table in excelsql query excelvba access sqlhow to copy columns to rows in excelexcel nested if and statementsvba dynamic arrayexcel spreadsheet passwordvba collectionsexcel appendbest excel book for data analysisupdate query in vbaconcatenate in vbaexcel macros vbaexcel macro columnloop in vbaplanner format for excelexcel macros tutorialvbscript write to text filevba clean functioncreate a userform in excelexcel macro to open files in a foldersas macros basicsvba excel instrlearn vlookup in excel 2007macro programingwhat is macros in excel 2007microsoft excel autofithow to prepare pivot table in excel 2010vba open files in folderchart layout excelhow to create stacked bar chart in excel 2010lookup formulaexcel vba lookup value in arrayunderstanding excel macrosvba declare arraypassword worksheetexcel color cellsmacro unprotect all sheetshow to put a title on excel graphpivot table refresh vbavba interior colorhow do i delete blank rows in excelcheck box on exceltcs business analyst interview questionsdashboard reporting templatescheck duplicate excelselect rows vbaunprotect excel sheet without password 2007excel formula replacewhat is excel ribbonshort cut keys for excelexcel formulas tutorialwhere is chart wizard in excel 2010headers in excelvba excel chartexcel combo boxtelephonic interview questions and answers pdf