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 2 comments
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: