Before diving into theory and the hands-on examples of this chapter, let's start by going over several terms that will be used throughout this chapter.

Collection — An object that contains a set of related objects.

Class — A definition of an object that includes its name, properties, methods, and events. The class acts as a sort of object template from which an instance of an object is created at run time.

Class Module — A module that contains the definition of a class, including its property and method definitions.

Event — An action recognized by an object, such as a mouse click or a keypress, for which you can define a response. Events can be caused by a user action or a VBA statement, or can be triggered by the system.

Event Procedure — A procedure that is automatically executed in response to an event initiated by the user, program code, or triggered by the system.

Form Module — A module that contains the VBA code for all event procedures triggered by events occurring in a user form or its controls. A form module is a type of class module.

Instance — A specific object that belongs to a class is referred to as an instance of the class. When you create an instance, you create a new object that has the properties and methods defined by the class.

Module — A structure containing subroutine and function procedures that are available to other VBA procedures and are not related to any object in particular.

Part I

0 0

Post a comment