👉 Ready to master VBA?
- Check out my full courses: [ Ссылка ]
- Subscribe to the channel here: [ Ссылка ]
- Get your free Arrays/Dictionary/Collections cheat sheet here: ([ Ссылка ])
(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.
![](https://i.ytimg.com/vi/tg7Vrlxh_RQ/maxresdefault.jpg)