Updated June 12, 2023
PART- 4 – Visual Basic Editor (VBE) – Properties
Transcript for Video – Visual Basic Editor (VBE) – Properties
Video on Visual Basic Editor (VBE) – Properties – Hello everyone what we did last time was what about the VBA project explorer file were we had seen that VBA excel files treated as project and within each project there are object like Microsoft excel objects form modules and class module and within each module within each project you know we can write sub routine like this within sheet 1, sheet 2 sheet 3 sheet 4 and so on so forth and we also saw that there was certain limitation associated with writing codes within each sheet when and looked at why module were required and modules help the VBA coders to kind of make this organizationally way better than writing codes individually across the work sheet so modules were much better the coders it is helpful in terms of you know identifying all code the codes which you may have written in addition we had also discussed you know different kinds of objects like forms and class modules very limited extend what we are going to do now is a that this something called properties here so there is the property window if I click on properties window you will find out this pops up what exactly this actually means so for this I’ll open a notepad and kind of you know give you kind of example let’s say you have a pen a pen would be kind of treated as an object it is basically an object which you can touch write now if I think about the properties of a pen now what kind of properties it could actually have pen could be Redding it can have blacking it can have greening, Blueing these are certain set of properties within the pen now this could be Nip Pen it could be Gel pen a Ball point there are certain other properties which I am trying to associate pen itself typically could be of different color or shapes can be big pen, can be small pen so as we can see when pen is an object it has different properties associated with it right so likewise when we are calling these on the left hand side these sheet 1 this are object so the movement we click here there are certain properties associated with that object so it can have name so we have actually written a name as A likewise you know it can have different set of properties like this display page breaks, display right to left, so this can be looked at from this properties windows so just a give you example here let say the visibility in a sheet is visible now, so tis sheet name A is visible so let say what if I make it as o which is hidden so what will happened to my worksheet so as we can see my sheet a is actually hidden now so this is how probably you would kind of utilize the properties to an extent possible I think a better example here could be related to user form let say when we talk about user form click on use form you will find that there is whole box that opens up and this box actually is used for designing various forms which are esthetically pleasing as well as kind of very useful so we will be discussing how to create user forms for the time being I just wanted to highlight what are the properties associated with these user forms so you can see here that you know these user forms have different color styles a maybe I may want to kind of change the back color let say yellow so you can change this you can change the border style may you can also change the font something like this were you have regular one size 8 you can change it to 12 or probably you know certain set of properties associated with each objects and that’s why you know these are kind of very useful likewise in module you will find that there are certain properties so one of the properties was its name which could be used within the VBA editor so something like this so let say if I want to change the name of this module I can’t just click here and right click you know probably use some think like change name which we normally do for the other window explorer files but here you can change it within the VBA editor by clicking here on module 1 and let say this is a this module is called as Department so it will kind of change let say module 2 was employees so this modules can be named and probably now you will realize that why this could be organizationally better because we could easily name this and you know code this separately so again excellent feature provided here a one clean difference I guess which we must also look at is when I click on sheet 1 you may note that there are 2 name here there is name within the bracket which says sheet 1 so obviously this is sheet 1 and there is name here and it says A so earlier we had hidden the sheet let me just make it as visible sheet and what essentially there are 2 names is all about that this A, B, C, D, E this is what shown in the 2nd name right so this is what is the displayed name one which is within the bracket is basically used for the VBE editor to identify the object so don’t worry too much about all this things clear difference could be identify when you actually click on department modules here the modules actually only internal to the VBA editor you will not find modules or say for example user form within the VBA project excel file here you don’t find user form and modules here as display so they have only one associated with them however when you talk about the sheet there are 2 names so I guess that’s what all about the properties explorer you can actually use a shortcut which is F4 to open up this properties as well