Why custom collections lack item.index?

[prabha_friend]

How to make it indexed? and How to retrieve it using item.index?

P.S:
First time on Collection.

 

[RoryA]

Write your own Index property. Absent any detail at all as to what you have currently, I can't be more specific.

 

[prabha_friend]

Write your own Index property. Absent any detail at all as to what you have currently, I can't be more specific.

Thought earlier, that index is a native property of collections (Like sheet.index). Now only know, we have to build it.

for each Item in MyCollection.items
msgbox item.index
Next item

Do we have to craft a class file to build extra properties on a collection?

Thanks to your answer.

 

[RoryA]

What is MyCollection there - a native VBA Collection?