And for this the code will be: Boxes(“Red”).Open Let’s go a bit specific, let say if you want to open the box which is RED in color. It’s plain English, Right? But when it comes to VBA and writing a macro this will be: Box.OpenĪs you can see, the above code is started with the box which is our object here, and then we have used the method “Open” for it. The words you will use would be “Open the Box”. There are objects, collections, methods, and properties which you can use in VBA to write your code.ĭon’t miss this: Let’s say you want to tell someone to open a box.
In simple words, first, we define the object and then the activity which we want to perform.
VBA is an Object-Oriented Language and as an object-oriented language, in VBA, we structure our codes in a way where we are using objects and then defining their properties.
0 kommentar(er)
