How to Implement support for enumeration (For Each) in a collection class in Excel ?

[Radu]

Hi. I have created a collection class, and I would like to allow the
user of this class to enumerate (using 'for each').

In VB I would use

Function NewEnum() As IUnknown
'Implement support for enumeration (For Each)
Set NewEnum = m_colTruckingCharges.[_NewEnum]
End Function

But in Excel IUnknown does not show in my object browser, and when I
try to use it, I get "Object doesn't support this property or method".

Can this be done in Excel ? How ? Do I need to set a specific
reference, maybe ?

Thanks a lot for your time.
Alex

 

[RB Smissaert]

Read this post:
How To: Collections in VBA in Excel and probably other MS Office 2003
applications.
dated 16 December 2005 in the newsgroup:
microsoft.public.excel.programming

RBS

 

[Radu]

Thanks a lot, that did the trick ! ))

Alex

 

[RB Smissaert]

Nice to help out.

RBS