Create Dictionary and KeyValuePair Classes in Excel VBA

Unlike in .NET framework, Microsoft Excel VBA doesn’t provide a Dictionary class. Here I have created a Dictionary class, rather collected, which allows adding items, checking the existance, looping each items easily. Along with the dictionary,¬†we have a second KeyValuePair class which comes in handy for a dictionary item.

Let’s create a Class in Excel and call it Dictionary and copy/paste the code below. Let’s open up an Excel VBA and follow the steps below.

Let’s create a class as shown

Create Class Module

Rename the class to Dictionary

Rename To Dictionary Class

Dictionary Class


We have used a KeyValuePair class above so create another class, rename it to KeyValuePair and paste the code below.

%d bloggers like this: