Excel 2007 VBA Programming with XML and ASP

Chapter 9Chapter 9

Working with

Collections and

Class Modules

Working with Collections + Declaring a Custom

Collection + Adding Objects to a Custom Collection +

Removing Objects from a Custom Collection + Creating

Custom Objects + Creating a Class + Variable Declara-

tions + Defining the Properties for the Class + Creating

the Property Get Procedures + Creating the Property Let

Procedures + Creating the Class Methods + Creating an

Instance of a Class + Event Procedures in the Class Mod-

ule + Creating a Form for Data Collection + Creating a

Worksheet for Data Output + Writing Code behind the

User Form + Working with the Custom CEmployee Class

+ Watching the ...