title: List the properties of a class in VBA 2003
body: <p>I've searched all over to see if there is an easy answer to this question, but there doesn't seem to be...</p>
  
  <p>I'm using Excel VBA 2003 (yes, I know it's out-of date, but I can't change this), and all I want to do is list the names and values of all the readable properties in a given custom class.</p>
  
  <p>I'd like to do something like this:</p>
  
  <p><strong>Class definition (for class entitled cFooBar)</strong></p>
  
  <pre><code>Option Explicit
  
  Private pFoo As String
  Private pBar As String
  
  Public Property Get Foo() As String
  Foo=pFoo
  End Property
  
  Public Property Get Bar() As String
  Bar=pBar
  End Property
  </code></pre>
  
  <p><strong>Calling code</strong></p>
  
  <pre><code>Dim myFooBar as cFooBar, P as Property
  myFooBar=new cFooBar
  For Each P in myFooBar.Properties
  Debug.Print P.Name, P.Value
  Next
  </code></pre>
  
  <p>Of course, this doesn't work because there doesn't seem to be a "Properties" collection member for custom classes (or at least not one that you can get at), and there isn't a "Property" type either.</p>
  
  <p>Does anybody know a way around this?</p>
  
  <p>TIA,</p>
  
  <p>Campbell</p>