Scripting.Dictionary still commonly used in VBA?

Question

I had to cobble together some code in Excel/VBA and vaguely remember we used to add a reference to Microsoft Scripting Runtime to use Dictionary. Now in the days of Office 2010, is that still the preferred way of getting access to a Dictionary like structure or have things moved on?

Answer 1

Dictionaries are still used the same old way in Excel VBA -- Read more here Does VBA have Dictionary Structure?

But there is an alternative to dictionary objects, using Collections More about that here: Using Dictionary Object in Excel VBA