What is CreateObject Method in VBA and How to use CreateObject Method in Excel?

As the name suggests, the CreateObject function is used to create objects.  But why do we use CreateObject method or function if we can direct...

What is FileSystemObject (FSO) and How to Use it in VBA Excel?

The FileSystemObject is used to work with folders and files connected with the system. We can use it to access files, folders, drive, and text str...

How to Use InputBox Function in VBA Excel?

In excel, we have multiple ways to get input. We can get input using function arguments, use excel cells and ranges as input areas and then retrie...

How to Create Dependent Combobox in VBA Excel?

We know how to create a cascading dropdown on a worksheet using data validation. But how do we create a cascading combobox dropdown on VBA userfor...

How to Use ComboBox in VBA Excel Userform?

A combobox on a userform is like a drop down menu, which can be used to pick an option from the available options. It is like the drop down we create ...

How to Use Structures in VBA? The User Defined Data Types

Let's say you are trying to create a school management system. Here, you will have different types of variables like student name, student roll no, cl...

VBA Class Modules and How to Use Them

What is a Class in VBA? A class is a blueprint for an object to be created. A class itself does nothing but using classes you can create multip...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.