Macros & VBA Training Series BONUS VIDEO:

7 Ways to Run Your Macros in Excel

Double-click the video to view in full screen HD.

Here is a list of the 7 ways to run a macro that I discuss in the video:

  1. Step into the macro from the VB Editor – F8
  2. Run the macro from the VB Editor – F5
  3. Macros button on the View tab of the Excel Ribbon – Alt+F8
  4. Assign a macro to a Shape in a worksheet – Right-click shape > Assign Macro…
  5. Assign a macro to a Form Control Button on the worksheet – Developer tab > Insert > Form Control Button
  6. Type name of the macro in the Immediate Window in the VB Editor – Ctrl+G
  7. Use Events from the ThisWorkbook code module – Call the macro from the event code/macro.

The videos above are from Module 1 of The VBA Pro Course.  This course is a step-by-step learning system that will take you from beginner to VBA expert.  Click the link below to learn more and enroll in the course.

VBA Pro Course Beginner to Pro Banner 480

Click Here to Learn More About the Course

Please leave a comment below with any questions.  Thanks!

Click Here to Leave a Comment Below 3 comments
Donna - July 19, 2018

Have you ever had a macro that does not produce the desired result if you run it, but does exactly what was intended if you step-in through each command? I have this problem with one I’ve written to complete several tasks on multiple worksheets. I’ve tested it over and over, but can’t identify the problem since it works perfectly in edit as I step through using F8. Any suggestions would be greatly appreciated.

Reply
Arash - May 27, 2016

Hi Jon
thanks. for learn Ways to Run Macros in Excel

Reply
Jon Acampora - March 18, 2016

I just published a blog post and video series on how to create a Personal Macro Workbook. This includes a video on how to customize the Excel ribbon to add tabs and buttons to run your macro. You can also add buttons to the Quick Access Toolbar to run your buttons.

Personal Macro Workbook Video Series

So there are two more ways to run your macros! 🙂

Reply

Leave a Reply: