How to get property values of classes that implement an interface in the Locals window?
I could be wrong, but I think this may be something to do with the way classes are instantiated in VBA.
For example:
Dim oClass1 as Class1Set oClass1 = new Class1
Is different than
Dim oClass1 as New Class1
In the second case I believe the constructor doesn't get called until the property is accessed.
If you try this, it is sees the property in the Watch window. Notice the New for the IClass - just for Demonstration - I know its not the way to do that :)
Public Sub test1() Dim x As Class1 Dim y As IClass Set y = New IClass Set x = New Class1 Debug.Print x.Name Debug.Print y.Name StopEnd Sub
I suspect its something to do with that and the watch window requires this ... maybe...