Back to Browse

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

4.9K views
Apr 15, 2022
12:24

Get the Excel VBA Objects Guide for Intermediate with extended and revised content here: https://excelmacroclass.blogspot.com/p/excel-vba-objects-guide.html 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. 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/)

Download

1 formats

Video Formats

360pmp414.4 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

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