Listing keys in a collection

[venkman]

How do you list the keys in a collection?

For instance:

dim col as new collection
dim v as variant
col.add "item1", "key1"
col.add "item2", "key2"
for each v in col.keys
msgbox "key: " & v
next

would display two message boxes:
"key: key1"
and
"key: key2"


What's the equivalent of col.keys in the code above?

Thanks,
-Venkman

 

[RobBroekhuis]

I don't think you can do that. The key is used only to refer to a specific item in the collection, you can't actually read it, as far as I can tell.
Rob

 

[venkman]

Okay, here's the problem I'm running into. I have a bunch of info that I'm storing in a collection of custom objects that are referenced by value (a number), which I'm using as the key. Sometimes, the person(s) using the macro will enter in a duplicate entry. This causes the macro to have an error right now because keys must be unique. Is there a way to trap this error and call a subroutine instead (which will most likely give a dialog box, explaining to a non-technical person what caused the error)?

Thanks,
Venkman

 

[venkman]

never mind, using on error and err.number. Let me know if there's an alternative though.

 

[RobBroekhuis]

Venkman, your approach is the one I'd use.
Rob