Watch these 28 minutes if you want to become an Advanced VBA user...

Watch these 28 minutes if you want to become an Advanced VBA user...

In this video, I'm going to show you how to master using Arrays, Collections and Dictionaries in VBA. If you can grasp what is covered in the video then you are well on your way to becoming an advanced VBA user. Make sure to download the code from the link in the description so that you can try out the examples for yourself.

#VBACollection #VBADictionary #VBAArray

SUBSCRIBE TO THE CHANNEL: https://bit.ly/36hpTCY

DOWNLOAD THE SOURCE CODE FOR THIS VIDEO: https://bit.ly/3PprNZ8
(Note: If the download page doesn't work then make sure to turn off any popup blockers)

Related Training
The Excel VBA Handbook Course(https://TheExcelVBAHandbook.com)
Webinar Archives - 60+ Hours of VBA training(https://excelmacromastery.com/excel-v...)

Free Excel VBA Resources
Excel VBA Articles (https://excelmacromastery.com/vba-art...)

Useful VBA Shortcut Keys
========================

Debugging:
Compile the code: Alt + D + L OR Alt + D + Enter
Run the code from the current sub: F5
Step into the code line by line: F8
Add a breakpoint to pause the code: F9(or click left margin)

Windows:
View the Immediate Window: Ctrl + G
View the Watch Window: Alt + V + H
View the Properties Window: F4
Switch between Excel and the VBA Editor: Alt + F11
View the Project Explorer Window: Ctrl + R

Writing Code:
Search keyword under cursor: Ctrl + F3
Search the word last searched for: F3
Auto complete word: Ctrl + Space
Get the definition of the item under the cursor: Shift + F2
Go to the last cursor position: Ctrl + Shift + F2
Get the current region on a worksheet: Ctrl + Shift + 8(or Ctrl + *)
To move lines of code to the right(Indent): Tab
To move lines of code to the left(Outdent): Shift + Tab
Delete a Line: Ctrl + Y(note: this clears the clipboard)

Table of Contents:

00:00 - Introduction
00:17 - How to use Arrays with Ranges
08:36 - Arrays vs Dictionaries/Collections
09:53 - Example 2: Unique values - Array
13:45 - Example 2B: Using Transpose
14:53 - Collection basics
16:49 - Example 2: Unique values - Collection
18:32 - Dictionary Basics
20:39 - Example 2: Unique - Dictionary
22:07 - Example 3: Sum Data Dictionary
25:02 - Example 4: Sum Multiple fields