title: How to monitor the values in a Dictionary in the Excel VBA watch window?
body: <p>I am using dictionaries in Excel VBA via <code>dict As New Dictionary</code> (and adding a reference to the scripting runtime). When I try to monitor those during debugging, I can only see the keys which lie in the dictionary, but not the respective value of each key.</p>
  
  <p>Is there any way to see the value as well? It would make debugging much more easy for me.</p>
  
  <p><strong>EDIT:</strong> Based on your answers, there is no easy solution, but I can do the following. </p>
  
  <p>Use a global variable <code>Dim d_obj As Object</code> and monitor it constantly and whenever I need to look up a value of a dictionary, I type into the immediate window <code>Set d_obj(key) = ...</code> and I will be able to see the value in the monitor-window. </p>
  
  <p>What I may do in addition is write a function which takes in a dictionary and returns the values as a list and use this function similarly at the direct window. Thx to all!</p>