Chapter 12. Working with Collections
After completing this chapter, you will be able to:
Manipulate the Controls collection on a form.
Use a For Each … Next loop to cycle through objects in a collection.
Create your own collections for managing Web site URLs and other information.
Use VBA collections within Microsoft Office.
In this chapter, you’ll learn how to use groups of objects called collections in a Microsoft Visual Basic program. You’ll learn how to manage information with collections and process collection objects by using For Each … Next loops. When you combine collection-processing skills with what you learned about arrays in Chapter 11 you’ll have much of what you need to know about managing data effectively in a program, and you’ll have ...