Excel VBA: Practical Guide to Start Using Dictionary [4 Awesome Examples]

Excel VBA Dictionaries explained in simple terms. Advanced concepts made easy. Unravel the benefits of this awesome tool and take your VBA programming to the next level.

We will cover 4 practical use-cases
1. Find Unique Values from a List
2. Perform Sum & Count on Grouped Values
3. Copy & Paste Data Dynamically
4. Perform VlookUps

#vba #learnvba #excelvba #excel #exceltutorial #exceltips

Dictionaries may be a tough concept to grasp. And that's too bad. Because there are so many great ways to use them in our everyday coding. This video will go get you started with using dictionaries ASAP.
Learn the basics of dictionaries and directly start using them in some useful examples.

All code is available at my blog site:

Course file is uploaded to Github:

00:00 Intro
1:33 What is a Dictionary?
2:22 Main Features
3:25 How to Use Dictionaries
9:05 Initial Setup
10:54 Example 1: Find Unique Values from a List
13:02 Example 2: Perform Sum & Count on Grouped Values
17:04 Example 3: Copy & Paste Data Dynamically
21:05 Example 4: Perform VlookUps
23:49 When To Use Dictionaries

[adamonjourney]

Great teaching method! Well done! Thanks for your efforts!

[philwhyte]

Hi there, well done on creating a very informative and educational tutorial. I have now subscribed and look forward to the Dictionaries with Class Objects. Thank you.

[Kuldeep]

Thank you sir for this very good tutorial. I am new to VBA. Could you please advise me in making a use of this tutorial in my personal situation. I have two sheets. Sheet1(target) has a column of account ids. The second column needs to be populated from sheet2(source).Sheet2 has a column of account ids and its respective amounts. I tried to create a sample test by creating a macro based on your fourth part of the tutorial. You have created two separate loops one for countries(source) and another for players(dest). Once the first loop is over and proceeds to second loop, the data from first loop doesn't get carried over to the second loop. As I said, I am a beginner, your help here will be much appreciated. Regards.

[shridharsahu]

Hello Iam not able to pass a variable for key, it takes the actual variable name as key but not the value it holds, why so please xplain if there is a. Solution.

[kaanapadhiyar]

Sir make code for
if Cell contain value greater than 0 then cut entire row into another sheet

[kaushalkumar-fkxr]

There is nothing in 25 minutes video, it should be 3, 4 minutes