XL97: How to Programmatically Create a Collection (161215)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q161215 SUMMARY
New programming functionality in Microsoft Excel 97 allows you to create a
collection. A collection is a predefined object that stores groups of
related objects. A collection makes it easier to work with the object
group. For example, you can use a For Each looping structure to loop
through the collection. Each time the macro executes the loop it references
a different object in the collection until all objects in the collection
are referenced once.
This article includes a sample Visual Basic for Applications macro that
creates and references a collection.
REFERENCES
For more information about the Add Method, click the Index tab in
Visual Basic for Applications Help, type the following text
and then double-click the selected text to go to the "Add Method (Visual
Basic for Applications)" topic.
For more information about Collections, click the Index tab in
Visual Basic for Applications Help, type the following text
and then double-click the selected text to go to the "Collection Object"
topic.
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbdtacode kbProgramming KB161215 |
---|
|