title: Retrieve the index of an object stored in a collection using its key (VBA)
body: <p>I have a collection with several elements in VBA, each of these elements has a key assigned.</p>
  
  <p>I would like to know the position of a given element in the collection using its key. The only way I can think of doing it is to make a loop through the collection until I get the item I want, is there a faster approach?</p>
  
  <p>Thanks</p>