Here is my shot at no Collection solution, meaning a two class module solution: the one is for the item and the other is the actual class. SelfCallback is such a wonderful thing to exist!
The class is very simple, it just has minimal Add, Count and Item properties. All the other code is dedicated for the enumeration effect to have the support for For Each without a Collection.
Originally Posted by MSDN
You can't write an enumerator object with Visual Basic