👉 Ready to master VBA?
- Check out my full courses: [ Ссылка ]
- Subscribe to the channel here: [ Ссылка ]
- FREE CHEAT SHEET: Get the free cheat sheet on VBA arrays here: [ Ссылка ]
(Note: If the download page doesn't work then make sure to turn off any popup blockers)
In this Excel VBA video, we see how to use Class modules objects with Collections. One of the problems with collections is that it can only store one item from a row of data.
So how to we store data from multiple columns? We use class module objects.
In this video you will see how to create class module objects to store our data and how to add the modules to a collection. Finally we will see how to read the data from these class module objects to a worksheet.
Table of Contents:
00:42 Reading from a worksheet to a collection
03:11 Creating a Class Module
04:43 How to use the Class Module
07:15 Using the Class Object with a Collection
10:57 Write from the class objects to a worksheet
Related links:
The Ultimate Guide to Collections in Excel VBA: ([ Ссылка ])
Get your free Arrays/Dictionary/Collections cheat sheet here: ([ Ссылка ])
The Excel VBA Handbook Course([ Ссылка ])
Webinar Archives - 60+ Hours of VBA training([ Ссылка ])
Shortcut Keys:
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).
