Excel VBA Dictionary Object, It's Great :)

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:
github.com/VBA-tools/VBA-Dict...
How to sort a Collection:
stackoverflow.com/questions/3...
How to sort a Dictionary and more great details about the dictionary object:
excelmacromastery.com/vba-dic...

[@karolispulokas1364]

Many thanks. Amazing content. Really surprising so few views given so many gems here. Your methods in using VBA promote best practice and I really like it.

[@Ashish-2319]

The code for sorting was really great✌

[@philipmcdonnell7168]

Hi Ben, ExcelMacroMastery is Paul Kelly's site. I've found Tim Hall on GitHub but am a bit baffled. (I use a Mac at home which is why I am keen to get the Dictionary as MS's store is devoid of any mention. (I am running M365)

[@philipmcdonnell7168]

I found it in Tim Hall's GitHub repo under VBA-Tools

[@philipmcdonnell7168]

I can't get it to import though...

[@andrewscoins5013]

Good evening sir, I have a question. Is it possible to perform multiple calculations in one userform? As an explanation I have written the calculation explanation in the comment. But I want you to know that I am not logged in to Facebook and I don't plan to do so. In textbox 1 I want to calculate Sum ifs Sum range column M Criteria range1 Column A Criteria1 is not empty criteria range2 column A Criteria2 is in the past or today's date Criteria range3 Column B Criteria3 = "Bank Criteria range4 column C Criteria4 = "Start value In textbox2 should be calculated Sum ifs Sum range column M Criteria range1 Column A Criteria1 is not empty criteria range2 column A Criteria2 is in the past or today's date Criteria range3 Column B Criteria3 = "Bank Criteria range4 column C Criteria4 = "+". In text box 3 the following should be calculated Sum ifs Sum range column M Criteria range1 Column A Criteria1 is not empty criteria range2 column A Criteria2 is in the past or today's date Criteria range3 Column B Criteria3 = "Bank Criteria range4 column C Criteria4 = "-" In text box 4 value from textbox1+value from textbox2 value from textbox3 In textbox 5 should be calculated Sum ifs Sum range column M Criteria range1 Column A Criteria1 is not empty criteria range2 column A Criteria2 is in the past or today's date Criteria range3 Column B Criteria3 = "wallet Criteria range4 column C Criteria4 = "Start value In textbox6 should be calculated Sum ifs Sum range column M Criteria range1 Column A Criteria1 is not empty criteria range2 column A Criteria2 is in the past or today's date Criteria range3 Column B Criteria3 = "wallet Criteria range4 column C Criteria4 = "+". In text box 7 the following should be calculated Sum ifs Sum range column M Criteria range1 Column A Criteria1 is not empty criteria range2 column A Criteria2 is in the past or today's date Criteria range3 Column B Criteria3 = "wallet Criteria range4 column C Criteria4 = "-" In textbox 8 value from textbox5+value from textbox6 value from textbox7 In textbox 9 should be calculated Sum ifs Sum range column M Criteria range1 Column A Criteria1 is not empty criteria range2 column A Criteria2 is in the past or today's date Criteria range3 Column B Criteria3 = "Checkout Criteria range4 column C Criteria4 = "Start value In textbox10 should be calculated Sum ifs Sum range column M Criteria range1 Column A Criteria1 is not empty criteria range2 column A Criteria2 is in the past or today's date Criteria range3 Column B Criteria3 = "Checkout Criteria range4 column C Criteria4 = "+". In text box 11 the following should be calculated Sum ifs Sum range column M Criteria range1 Column A Criteria1 is not empty criteria range2 column A Criteria2 is in the past or today's date Criteria range3 Column B Criteria3 = "Checkout Criteria range4 column C Criteria4 = "-" In textbox 12 value from textbox9+value from textbox10 value from textbox11 It would be really great if you could help me as I need to make my work easier as I have physical problems. Financially at the moment is also not much possible the Kind regards Andrew Scoins

[@databen7194]

Hi Andrew, it's not something I can look at, but perhaps this video will help? : ruclips.net/video/HPh68Mx4VE4/видео.html

[@andrewscoins5013]

@@databen7194 Thanks but unfortunately this will not help me