Identify object associated with a code pane

[swaatacba]

The following code iterates through all the open projects and the code panes associated with a project.

It does not identify the type of object (Microsoft Excel Object, Form, Module, Class Module) that the code pane is linked to. Is there are way of identifying that association?

Please Login or Register  to view this content.

[romperstomper]

It doesn't iterate through code panes, it iterates through the VBComponents, and they each have a Type property...

[swaatacba]

Thank you. They do indeed have a type property, but since this is an integer value it is not very meaningful. Is there a list of the descriptions for each integer value?

[ByteMarks]

How about

Please Login or Register  to view this content.

[swaatacba]

How about

Thank you. I was getting there but your approach is significantly more comprehensive.

[ByteMarks]

You're welcome