Sams Teach Yourself Microsoft

Chapter 13. Storing Information in a Collection

For many years, computer science curricula at universities taught data structure classes that included instructions on how to manage dynamic arrays. A dynamic array is a very simple data structure (see Hour 12, “Managing Varying Amounts of Data”). Object-oriented programming hit the PC mainstream around 1990. Since then, many PC programming languages, including VBA, have adopted object-oriented idioms. What this means to you and me is that code, once written, can be used more easily by many developers.

A collection is just the sort of advantage object-oriented programming provides. In the most basic sense, a collection is a dynamic array, written as a class and incorporated as part of the VBA language. ...