title: printing a collection item to immediate window in excel vba
body: <p>I was wondering how do I print an item in my collection to the immediate window in excel VBA? I want to either have a collection for each collection item or an array for each collection item, which ever is easier to pull information from. Here is some example code of what I'm talking about</p>
  
  <pre><code>Sub test()
  
  Dim c As Collection
  Dim a As Collection
  
  Set a = New Collection
  
  For i = 1 To 10
      Set c = New Collection
      c.Add Array("value1", "value2", "value3","valvue4, "value5"), "key1"
      c.Add "value2", "key2"
      c.Add "value3", "key3"
      c.Add "value4, "key4"
      c.Add "value5", "key5"
  
      a.Add c, c.Item(1)    
  
  'lets say I wanted to print value4 or value1 from the 1st item
  Debug.Print a.Item(1(2))
  
  Next i
  
  End Sub
  </code></pre>