Excel VBA Collections: How to use Collections (1/5)

👉 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)

This video shows how to use Collections in Excel VBA. Collections are used to store a group of similar variables.

In this video you will see:

How to declare and create a collection
How to add, insert and remove items from a collection
How to get the number of items in a collection
How to use the Watch Windows to check the contents of the Collection

Table of Contents:
00:48 Why do you need a Collection?
02:15 How to declare a Collection
04:00 Adding items
06:00 Inserting items
07:24 Get the number of items in a Collection
09:07 Removing items

Shortcut Keys:
Ctrl + G: View the Immediate Window.
F5: Run the code from the current sub.
F9(or click left margin): Add a breakpoint to pause the code.