Excel VBA Objects: Excel Object Model And Object Hierarchy

Welcome to the Excel VBA Objects Series. This first video is an introduction to the Excel Object Model with explanation around the object hierarchy. It shows how to code throughout the hierarchy of objects in Excel VBA. In the following videos we'll see the difference between objects and collections, dig into the structure of properties and methods, discover events, and see how to work with the object browser and automatic listing while coding.

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.

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:

[discordggspreadsheet]

Not the sexiest VBA subject but it is super useful, great video

[jmunozSV]

I like the easy way you explain your content
Y will buy your material
Thanks much

[bejai]

I can learn a lot from you! Is there a specific order to watch this series for a beginner?

[elhabibbirouk]

I have purchased the ebook. How to get my copy?

[dalskiBo]

The trouble with vba is it is inconsistent; insisting on objects being selected first, other times not required... The object browser gives inadequate detail & specification on how they are used... A horrible language. Take the AutoCorrect class; object browser states it is a member of Excel. But to use it you need to use Application.AutoCorrect then the appropriate property/ method... It does not state this in the object browser.