title: Setting the Item property of a Collection in VBA
body: <p>I'm surprised at how hard this has been to do but I imagine it's a quick fix so I will ask here (searched google and documentation but neither helped). I have some code that adds items to a collection using keys. When I come across a key that already exists in the collection, I simply want to set it by adding a number to the current value.</p>
  
  <p>Here is the code:</p>
  
  <pre><code>If CollectionItemExists(aKey, aColl) Then 'If key already has a value
      'add value to existing item
      aColl(aKey).Item = aColl(aKey) + someValue
  Else
      'add a new item to the collection (aka a new key/value pair)
      mwTable_ISO_DA.Add someValue, aKey
  End If
  </code></pre>
  
  <p>The first time I add the key/value pair into the collection, I am adding an integer as the value. When I come across the key again, I try to add another integer to the value, but this doesn't work. I don't think the problem lies in any kind of object mis-match or something similar. The error message I currently get is </p>
  
  <blockquote>
    <p>Runtime Error 424: Object Required </p>
  </blockquote>