Excel VBA Objects: Properties and Methods
HTML-код
- Опубликовано: 31 мар 2022
- Get the Excel VBA Objects Guide for Intermediate with extended and revised content here: excelmacroclass.blogspot.com/...
Welcome to the Excel VBA Objects Series. In this video we'll see the difference between object properties and methods, and also how to use them correctly. Excel VBA can get and modify the attributes and state of objects through properties and methods. A property is an attribute of an object or an aspect of its behavior (e.g., color, size, etc). A method is an action that can be applied to an object (e.g., open, copy, etc). We apply properties or methods to an object using the relevant object reference followed by the property or method separated by a dot (period). In the next video we'll work with object events, see the different types of events in Excel VBA, and also 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: 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 (excelmacrofun.blogspot.com/)
Excel Macro Business (excelmacrobusiness.blogspot.com/)
Excel Macro Sports (excelmacrosports.blogspot.com/)
Always waiting for your videos
More to come!
Do we need to pay anything else for the material you are showing in this video
Not at all. You have a full series of videos (a playlist) about Excel VBA objects in the channel and a lot of resources in my blog: excelmacroclass.blogspot.com/