title: How to change value of an item of a collection
body: <p>With this code (in excel-vba) I add to a collection a number of items depending on an array.<br>
  I use the value of the array as key and the string "NULL" as value for each item added.</p>
  
  <pre><code>Dim Coll As New collection
  Dim myArr()
  
  Set Coll = New collection
  myArr() = Array("String1", "String2", "String3")
  
  For i = LBound(myArr) To UBound(myArr)
      Coll.Add "NULL", myArr(i)
  Next i
  </code></pre>
  
  <p>Now, if I want to change the value of an item, identifying it by the key, I must remove the item and then add an item with same key or is it possible to change the item value?</p>
  
  <p>This below is the only way?</p>
  
  <pre><code>Coll.Remove "String1"
  Coll.Add "myString", "String1"
  </code></pre>
  
  <p>Or is there something like: (I know that doesn't work)</p>
  
  <pre><code>Coll("String1") = "myString"
  </code></pre>