Excel VBA || Calling Subs and Functions || Parent - Child Architecture || Make your code smarter
Learn HOW to Call Subs and Functions from your Current Sub. We will cover the Parent Sub - Child Sub Architecture that will guide you to organize your code and build scalable projects.
Most of you might be used to working with Single Sub VBA macros, where the end-to-end flow is bundled into a Single Macro. In this video, we will learn how to distribute our code to different (child) subs and functions.
We will first, deep dive into the theory of Sub-Procedures and Functions. Then, we will do a Practice Session where we covert (Refactor) a Large, Single Macro into Multiple Bite Sized Subs and Functions. And last, but not least, we will look at how to tackle error handling in a Multi-Sub Project.
Code can be downloaded from:
https://skillsandautomation.com/tutor...
Macro files can be downloaded from:
https://github.com/skillsandautomatio...
00:00 Intro
01:29 Benefits
04:31 Parent - Child Subs
06:43 Theory
16:27 Example - Walk Thru
20:52 Practice Session
43:49 Error Handling - Single Subs
48:33 Error Handling - Multi Subs
