title: Finding the key corresponding to an item in a dictionary
body: <p>Is there any way to find the key that corresponds to a given item in a VBA dictionary?</p>
  
  <p><a href="http://msdn.microsoft.com/en-us/library/aa164502%28v=office.10%29.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/aa164502%28v=office.10%29.aspx</a>
  MSDN suggests that the "Key" property can be used, but when I try using it I get an error ("Compile error: invalid use of property"). I've found in the past that the "Exists" method given here doesn't work for me either, so I assume that they were the commands in a previous version of Office and are now outdated. However I haven't been able to find an equivalent for the latest version of Office.</p>
  
  <p>I could use a for each loop to create a new dictionary where the keys in the old dictionary are the items in the new dictionary (and vice versa) and then use ".Item", but I was wondering if there was an inbuilt command that would allow me to avoid this.</p>