Your object will automatically be available to other users who have that add-in loaded. You can also turn your object into an Excel add-in. These controls all use VBA, and your new object can easily be incorporated into the event code for these controls. You can also use it where you have placed Active X controls onto a worksheet, such as a command button or a drop down. The Object has a number of properties and methods that can be accessed by your VBA code from anywhere within the workbook without having to keep re-writing the code over again.Īs well as referring to your new object from a standard VBA module, you can also use it in the code behind a UserForm that is part of your custom application When you create a new Object in this way, you are creating a building block which can be used anywhere within VBA.

In the Worksheets Object, you have a number of properties and methods which allow you to get the number of worksheets within a workbook or each individual name of a worksheet, or numerous other information The class modules work in a very different way to the ordinary modules in that they facilitate creating a Component Object Model (COM) which can then be used within your normal VBA codeĮffectively, you create an object which works in the same way as a built in Excel object such as ‘Worksheets’. When you insert modules into the Visual Basic Editor (VBE) in order to enter your code, you may have noticed that you can also insert what is called a ‘Class Module’. You’ll learn what they are and how to use them. This tutorial will teach you about Class Modules in VBA. Using a Class Module to Create a Variable Repository.Summary of Creating an Object Using a Class Module.

Visual basic for excel classes