If you do some VBA programming regularly, you’ll be acquainted with the Object browser, which neatly shows you all objects, properties and methods belonging to any object in Excel (or any other library you have referenced in your VBA project).
Whilst this is a tremendous tool to look for information on just a couple of properties I find it not very handy when you e.g. need to get all of an objects properties into your VBA code.
So I thought I’d roll my own object browser, just for the fun of it (and because it proved useful, I share it here).
The tool uses the tlbinf32.dll present on (I assume) any current Windows installation to fetch data from typelibraries. I grabbed some code from various places (amongst which Chip Pearson’s great site and some newsgroup messages like this one) and created a userform with a treeview control (because this is the type of control that can show hierarchical information so nicely).
Here is a screenshot of the tool:
Look here for a bit more information and the download link:
Jan Karel Pieterse
JKP Application Development Services