Microsoft® Office Excel 2003 Programming Inside Out

Chapter 14. Developing Class Modules

Introducing Class Modules

Properties, Methods, and Events

Building a Class

Practical Class Design

This chapter introduces the concept of classes. In this chapter, you’ll learn about classes, objects and why they aren’t the same thing. You’ll also learn how to construct classes in Microsoft Visual Basic for Applications (VBA), including defining their properties, methods, and events.

What Is an Object?

An object is a logical representation of a thing. The thing can be a physical entity such as a person, a flower, a machine, or a place. The thing can also be a logical entity such as a report, an order, or a transaction. The thing can also represent something on the computer such as a button, a cell, a worksheet, ...