Hey guys, welcome back. So in this video we're going to speak about objects in Excel VBA. So VBA or the Visual Basic for Applications language is an object oriented language. So VBA is full of objects, it revolves around objects actually. And all these objects have properties. And properties are like characteristics and methods, which are like behaviors or actions or verbs that the object can do.

So for example, when you describe someone as being told, okay, someone's height is a property. If you think about that person as an object, then he's height is a property. And also when you say that someone is walking or someone is running, running, or walking is a method. If you think about someone as an object, then walking or running is a method and if you think about stuff around us as objects, so for you Example. A car is an object, and it has some properties and methods. So part of the properties of the car is its color.

So color is a property because it's something that you can describe the car with the cars type, for example, as well, is it an SUV is that event, the cars brand, so is the Mercedes to BMW, Toyota, all these are properties. And the car has some methods as well. So moving when the car moves from one place to another, that is a method. So any object if you think about it has properties and methods and this is how excel vba works. If you think about your mobile phone as well. Your mobile phone has some properties such as its color, such as its screen size, and its brand as well.

Is it an iPhone is a Samsung, all these are properties for the mobile phone and it has some methods as well part to this methods are the actions that the mobile phone can do, it can call it can text, it can access the internet, all these are methods, if you think about yourself as well as an object, you have some properties and methods. So, parts of the properties or your heights, your eye color, your skin color, all these are properties. Some of the methods that you can do, you can eat, you can sleep, you can walk, you can run all these are methods, if you think about yourself as an object. Now, VBA has a lot of objects and as an example, of the objects that you will encounter in Excel VBA there is the range object. So the range object is basically the cells in an Excel spreadsheet.

A range object can be a single cell or multiple cells. So the range object has some properties, like the value of the cell. For example, the value is a property and test some methods such as the Select method, which is the method that you use to select the cell. Okay, this is a method This is an action that you're going to do to the cell. So this is why it's a method. There's also the worksheet object.

The worksheet is an object. So it has some properties such as its name. So the name is a property, the name of the worksheet. And there are also methods like the Select method to select the worksheet. This is an action that you're going to do so this is a method. There's also the copy methods worksheet copy method for copying the worksheet, the worksheet dot move as well.

The method for moving the worksheet as well. This is a method or an action that you're going to do to the worksheet. There's also the Excel workbook object. So your workbook as well is an object. It has some properties such as its name as well, and it has some methods such as opening the workbook. So workbook open is Method closing the workbook close is a method as well.

And we will learn about that in more detail as we progress through the course. There's also the Excel Application Object. So the Excel as an application is also an object that has some properties and methods. And also you need to understand that objects can contain other objects, and they are called container objects. So for example, the Excel application object contains the Excel workbook object, right because the workbook the Excel workbook is part of the Excel application. And also the Excel worksheet is part of the Excel workbook object as well because a worksheet is going to be inside a workbook and also the range object is contained inside the worksheets object as well.

Okay, so you need to understand the idea that objects can contain other objects. Also objects can be part of a collection. So we've got the idea of collections in Excel VBA and collections are like different families. So we've got the worksheets collection for example. So this is like the worksheets family, okay the family of worksheets and all objects that are part of a collection will have the same properties and methods, okay, so when we say the worksheets collection, that means that every worksheet belongs to this particular collection, and that all the worksheets will have the same properties and methods. We've also got the work books collection, so this is another family in Excel VBA, the workbooks family and the workbooks family contains all the workbooks in Excel VBA and all the workbooks because they belong to this family.

That is called the collection. have the same properties and methods. So all workbooks in Excel VBA will have the same properties and methods. There's also this cells collection object. So all the cells will belong to the cells collection object. And why are collections useful in Excel VBA?

Well, collections enable you to run code for all objects belonging to the same collection. So you can loop through a collection of objects to perform an action to every member of the collection, and we will learn about loops later on in the course. So basically, you can go through each member of a collection and perform an action to that member. So you can, for example, go through each cell in the cells collection and type a certain value to all the cells in the cells collection, for example, perform any other action, okay, so collections are very useful because To the enable us to run code for all objects belonging to the same collection, and we will see that as well as we progress into the course. Okay guys, so that's it for objects in Excel VBA. Thank you very much watching this video and I'll see you on the next one.