10 Different Ways to Run a VBA Macro in Excel

preview_player
Показать описание

The video describes the following methods to run a macro in Excel:

1. Run Excel macro from the View or Developer tabs
2. Run Excel macro through a shortcut key
3. Run Excel macro with the Debug 'Play' button
4. Run Excel macro from a shape (or button or other form controls)
5. Run Excel macro from an icon in the quick access bar
6. Run Excel macro from an icon added to the ribbon
7. Run Excel macro as a result of a worksheet event
8. Run Excel macro as a result of a workbook event
9. Run Excel macro following a hyperlink
10. Run Excel macro from another macro or procedure

And yet, if you want more, you can find various Excel templates, dashboards, and applications of different nature in the other blogs of the Excel Macro Mania saga:
Рекомендации по теме
Комментарии
Автор

Really useful and nicely quick - thanks!

peterarmstrong
Автор

Great video! I'll come back to this, very informative

vincent-fpwf