Retrieving ALL properties and values for unknown control type

[thesleepylizard]

Hi, here's the scenario. I have a subroutine:

Public Sub DumpProperties (c as Control)

As the name of the sub suggests, I want to be able to dump all of the properties for "c" into, say, the debug window.

I imagine the code would be something like:

Dim i as long
for i = lbound(c.GetProperties) to ubound(c.GetProperties)
    debug.print c.GetProperties(i).Name + ", " + c.GetProperties(i).Value
next i

You see what I'm trying to do? GetProperties doesn't exist, of course, but I'm sure there would be something like this. I'm just not sure what it is! Does anyone else know how this is possible?

Thanks for your time,
-Sleepy

 

[strongm]

I've provided an answer for this in thread222-244273