Tutorial by Examples | RIP Tutorial

Adding a Property to a Class

A Property procedure is a series of statement that retrieves or modifies a custom property on a module. There are three types of property accessors: A Get procedure that returns the value of a property. A Let procedure that assigns a (non-Object) value to an object. A Set procedure that assign...

VBA • Creating a Custom Class

Adding Functionality to a Class

Any public Sub, Function, or Property inside a class module can be called by preceding the call with an object reference: Object.Procedure In a DateRange class, a Sub could be used to add a number of days to the end date: Public Sub AddDays(ByVal NoDays As Integer) mEndDate = mEndDate + No...

VBA • Creating a Custom Class

Class module scope, instancing and re-use

By default, a new class module is a Private class, so it is only available for instantiation and use within the VBProject in which it is defined. You can declare, instantiate and use the class anywhere in the same project: 'Class List has Instancing set to Private 'In any other module in the SAME ...

VBA • Creating a Custom Class