How To Get Intellisense For Custom Collection?

[johnywhy]

how can i get Intellisense for collection items? example:

MyCollection(Key).SomeProperty

Where MyCollection(Key) returns a custom object (a custom class instance)

Here's how to make a Custom Collection:
http://www.dailydoseofexcel.com/archives/2010/07/04/custom-collection-class/

cheers!
johny

 

[shg]

Pass an array() of Things instead of a collection? Then you get IntelliSense on the elements of the array ...