I've found this article: http://www.developerfusion.co.uk/show/2929/2/ Which I thought it would be the answer for my problem. However, after implementing that solution, I'm still stuck. I have a little doubt with the collection. The items I'm adding to a collection are:
VB Code:
  1. Private iColumn As Integer
  2. Private iLine As Integer
  3. Private iGroup As Integer
  4. Private bValueSet As Boolean
  5.  
  6. Private n_txt As Long    'This was defined as object -> Now, soft referenced
  7. Private n_pct As Long   'This was defined as object -> Now, soft referenced
  8.  
  9. Private iValue As Integer
  10.  
  11. Private sPerColumn As String
  12. Private sPerLine As String
  13. Private sPerGroup As String
  14. Private sMissing As String
Which are member variables which can be accessed through public properties. The question is, should I add a soft reference into the collection or can I just add the object itself?