This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.
Object that stores data key, item pairs.
A Dictionary object is the equivalent of a PERL associative array. Items, which can be any form of data, are stored in the array. Each item is associated with a unique key. The key is used to retrieve an individual item and is usually a integer or a string, but can be anything except an array.
The following code illustrates how to create a Dictionary object:
Dim d 'Create a variable Set d = CreateObject(Scripting.Dictionary) d.Add "a", "Athens" 'Add some keys and items d.Add "b", "Belgrade" d.Add "c", "Cairo" ...