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/)
Негізгі бет Excel VBA Objects: Properties and Methods
Пікірлер: 4