Break Down Your Macro Into Steps - Pt1
Автор: XLWizardry
Загружено: 2025-12-16
Просмотров: 20
When designing macros for a substantial set of requirements, rather than having one macro that does everything, I prefer to break things down into smaller functional units of work each with a well defined purpose. This makes the code easier to understand, manage and troubleshoot.
In Part 1 (this video), I share with you how I determine what these functional units will be and how I present them to the user as a step-by-step series of macros that they can run individually from one central worksheet.
In Part 2, I show the code behind some of these macros.
Excel Version
Recorded using Excel Pro Plus 2021 (I use at home) but also applies to Microsoft 365 (I use in the office)
You cannot run VBA/Macros directly in Excel online
Excel Tips Playlist
• EXCEL TIPS
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
