Excel VBA Dictionary: How to use the Dictionary (1/4)

👉 Ready to master VBA?
Check out my full courses: https://courses.excelmacromastery.com/
Subscribe to the channel here: https://bit.ly/36hpTCY
Get your free Arrays/Dictionary/Collections cheat sheet here: (https://bit.ly/2MXsnz9)
(Note: If the download page doesn't work then make sure to turn off any popup blockers)

In this video you will see how to create and use a Dictionary in Excel VBA.

The Dictionary is an alternative data structure to the Collection and Array. The difference is that it contains a key and value which allow us to easily update values.

Table of Contents:
00:13 What is a Dictionary
01:12 How to add the Dictionary to VBA
01:47 How to add items to the Dictionary
02:57 How to update the value at an existing key
05:19 How to add to an existing value at a key

Shortcut Keys:
Alt + F11: Switch between Excel and the VBA Editor.
Ctrl + R: View the Project Properties Window.
Ctrl + Shift + 8(or Ctrl + *): Get the current region on a worksheet.
F5: Run the code from the current sub.
F9(or click left margin): Add a breakpoint to pause the code.
Tab: To move lines of code to the right(Indent)
Shift + Tab: To move lines of code to the left(Outdent).