➡️ Subscribe Now ➜ [ Ссылка ]

Once you understand the basic concepts of VBA, the very next thing is to understand how to refer to a object and how to use properties and methods to perform activities in Excel.

1. Cloth Store Example
In this section, I have shared the example of a cloth store to make you understand how objects are structured in Excel.

2. Excel Objects, Properties, and Method
In this section, we understand the concept of Objects and properties and methods that you can use with an object while writing a code in VBA.

3. Excel Objects Hierarchy
In Excel, there's a hierarchy in objects that you need to know before you start using them in your codes and refer them.

4. Referring to a Cell (With Full Hierarchy)
In this section, we will look at how you can refer to a cell by using full hierarchy of the objects in a code.

5. Simplify the Reference to an Object
Once you use the complete hierarchy of objects, next this is to simplify the reference by eliminating the objects that we don't need.

6. Identify Properties and Methods
Once you refer to a object, you get access to all the properties and methods. And in this part, we will learn to identify a property and a method.

7. Refer to a Workbook
In this section, you will use the workbook and refer to it by using the name, the serial number of the workbook, using ThisWorkbook, and using the ActiveWorkbook.

8. Refer to a Worksheet
In this section, you will learn use the worksheets object and check out of the properties and methods that comes with it.

9. Refer to a Range
In the end, you will learn to refer to a cell, use properties and methods along with that (select a cell, copy a cell or a range).

About ExcelChamps
The ExcelChamps YouTube Channel is the part of ExcelChamps.com Blog that helps people to learn Microsoft Excel by providing some high-quality blog posts. On ExcelChamps YouTube Channel, we provide videos of the same quality to make education more accessible to the people out there.

свернуть