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 ...

Get Microsoft® Visual Basic® 2010 Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.