MENU

Fun & Interesting

Excel VBA Dictionary Object, It's Great :)

Data Ben 6,139 4 years ago
Video Not Working? Fix It Now

Learn how to use the Dictionary object in VBA for Excel. They are great because you can add Objects and Arrays to dictionaries, making them so much more powerful than arrays! They also use the unique Key/Value pair system meaning no duplicates :) To use the Dictionary for Mac please download Tim Halls code first and import to VBA: https://github.com/VBA-tools/VBA-Dictionary How to sort a Collection: https://stackoverflow.com/questions/3587662/how-do-i-sort-a-collection How to sort a Dictionary and more great details about the dictionary object: https://excelmacromastery.com/vba-dictionary/

Comment