Excel VBA Objects: Object Browser and Automatic Lists (Object vs Class)

Welcome to the Excel VBA Objects Series. In this video we'll navigate the Excel object browser and learn to get the most of it. We will reconcile on the difference between object and class, and take a look at the reference libraries in Excel. We will also see how to use the automatic lists while coding. These include the list of properties and methods, list of constants, quick info, and parameters info. That's the exact same info we find in the Excel object browser. These tools can be very helpful, specially when learning Excel VBA. In this video, we'll see how to use the object browser to its max potential.

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:

[ebenasare]

Is there a document to learn all these objects, classes etc

[fabriceseka]

i buy your excel vba object book but i did't get it yet

[anarkiamusicmovie]

Hi somtime in Browser Object we have icone Blue, what is???