Up to now, you've been able to have only one record at a time of the custom object. To create more, a collection is needed. A collection allows more than a single record to exist at a time. For example, Worksheet is a member of the Worksheets collection. You can add, remove, count, and refer to each worksheet in a workbook by item. This functionality is also available to your custom object.

There are two ways of creating a collection: in the standard module or in a class module. Which you choose depends on your needs.

0 0

Post a comment