Selecting Item of Dictionary by Index # using VBA in Excel

Question

I am trying to load a combo box with the last item in a dictionary. I am trying to do something like this ComboBox1.Value = NodeColl.Item(NodeColl.Count) which would work with a collection, but does something strange when using a dictionary instead.

Answer 1

The behaviour is different because a Dictionary allows numeric keys.

Calling .Item actually adds an item with the given key so;

NodeColl.Item(NodeColl.Count)

Adds a new item with no value & a key corresponding to the count.

To access the ordinal item use .Items (which is an array of the items)

firstItem = NodeColl.Items(0)
lastItem  = NodeColl.Items(NodeColl.Count - 1)