Excel VBA || Transfer Dictionaries and Arrays through Functions || Make your code more manageable!
Love using dictionaries and dynamic arrays? But, is it just too much code to set up and difficult to read back? Then, try using them with Functions.
We can pass Dictionaries and Dynamic Arrays as Parameters through Functions and Sub-Procedures and even, return them back through Functions. Imagine initializing a whole dictionary in the background and just calling that function from your parent sub.
Today, we learn how to transfer an existing, monotonous piece of code with dictionaries and arrays into a compact block of code that just calls the functions and subs where everything is set up.
#excelvba
Resources:
Download the code from my blogsite:
https://skillsandautomation.com/usefu...
Download the macro from Github:
https://github.com/skillsandautomatio...
00:00 Intro
02:30 Review Base Code
04:40 Transfer Code to Functions
