VBA Training Series BONUS: 7 Ways to Run Your Macros

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!

3 comments

Your email address will not be published. Required fields are marked *

  • 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

  • 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