Iterate through keys in a VBA Collection

[billiboy]

Hi

I wonder if it is possible to iterate through the keys in a collection. Something like this:

    Dim col As New Collection
 
    col.Add "value1", "key1"
    col.Add "value2", "key2"
    col.Add "value3", "key3"
 
    For Each key In col.keySet
        MsgBox (key)
    Next

I want the result to be "key1", "key2" and "key3"

 

[Richard Schollar]

I don't believe you can - you'll need to use a dictionary object to do this. See this:

http://support.microsoft.com/kb/187234

 

[billiboy]

Thanks, it worked with a dictionary object!