Excel VBA Objects: Object vs Collection
Get the Excel VBA Objects Guide for Intermediate with extended and revised content here: https://excelmacroclass.blogspot.com/...
Welcome to the Excel VBA Objects Series. In this video we'll see the difference between objects and collections, and also how to reference a collection vs an object. Basically, objects of the same type form a collection. For example, the Workbooks collection contains all the Workbook objects in Excel. Furthermore, collections are actually objects themselves, and therefore, they have properties and methods too. We will see several examples of collections and their respective objects, and compare the list or properties and methods that apply to them. In the next video we'll see the difference between properties and methods, and dig into the structure to learn how to use them correctly.
The following videos in the series are going to focus on each of the most important Excel VBA objects individually. We will cover the Application object, the Workbook object, the Sheets and Worksheet objects, the WorksheetFunction object, the Range object, the Shape object, and the Chart object.
Find more content and numerous macro examples and other Excel VBA learning materials in the Excel Macro Class blog under the direct link: https://excelmacroclass.blogspot.com/
And yet, if you want more, you can find various Excel templates, dashboards, and applications of different nature in the other blogs of the Excel Macro Mania saga:
Excel Macro Fun (https://excelmacrofun.blogspot.com/)
Excel Macro Business (https://excelmacrobusiness.blogspot.com/)
Excel Macro Sports (https://excelmacrosports.blogspot.com/)
On this page of the site you can watch the video online Excel VBA Objects: Object vs Collection with a duration of hours minute second in good quality, which was uploaded by the user Excel Macro Mania 20 March 2022, share the link with friends and acquaintances, this video has already been watched 5,737 times on youtube and it was liked by 101 viewers. Enjoy your viewing!
