Consider using a table instead of a collection and what you want to do is
simple. If you use a collection, it is more complicated -- unbound forms or
temporary tables and such.
How you reference them depends on what kinds of objects are in the
collection, but assuming the objects in your collection have a Name
property, you could loop through them with:
Dim obj As Object
For Each obj In MyCollection
Debug.Print obj.Name
Next
To display them in a form, you could output a string to a tall text box, or
use AddItem with a listbox.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.