Find an item in a collection

[Darren Bartrup]

Hi all,
I'm having fun with collections. You know, the same kind of fun you have when you have to have a wisdom tooth out at the dentist.

I have set up a collection which contains two items. Each item contains 10 values.

In the locals window it looks like:
colQuestions
Item 1
Item 1(1) 213
Item 1(2) 340
Item 1(3) 565
Item 1(4) 65
Item 1(5) 3
.
.
.
Item 2
Item 2(1) 237
.
.
.

colQuestions.Count returns 2
ubound(colQuestions.Item(1)) returns 10

How would I return a certain value from these collections using both these methods as examples:
Return element 4 from Item 1
Return an element from Item 2 using the Key name.

Any help is greatly appreciated.

Darren.

 

[RoryA]

Depending on your key:

   Debug.Print colQuestions(1)(4)
   Debug.Print colQuestions("item 2")(6)

 

[Darren Bartrup]

Thanks for that Rory.

I can't believe it was that easy.
I've been trying:

colQuestions.Item(1).Item("Essex")

and many variations.

It's not quite working as I hoped - the key references the two items and not the elements of the array within each item.
Nevermind though, I've got a workaround.

Darren.