VBIDE Challenge #5 - Listing Procedures in VB Project

[mc84excel]

VBIDE - Visual Basic for Applications Extensibility 5.3

I am intrigued by the idea of writing code that will report on or edit existing code. Unfortunately I am yet to master the use of VBIDE - my skill level on this is currently little-to-none.

So every so often, I post a new VBIDE challenge hoping that some forum user will solve it for me (either from kindness and/or for the love of the challenge).


Here's challenge #5.

I am currently trying to list all procedures in a project (thank you, I know that MZTools already has the ability to do this). I have run into a problem and I want to know how to fix it. See code at bottom of this post.

When I run the Sub "ListMacrosUsedInTWB", I eventually hit a runtime error 35 (Sub or Function not defined) on the line

Please Login or Register  to view this content.

It keeps occurring on ThisWorkbook module on the following property

Please Login or Register  to view this content.

Here's my VBIDE module:

Please Login or Register  to view this content.

[mc84excel]

Finally found the solution through Google. Chip Pearson explains it.

http://www.pcreview.co.uk/forums/vbe...-t3894267.html

[mc84excel]

I was tweaking the code from Chip Pearson and have made a useful (well to me anyway) improvement to it. It now reports on the Type of Function or Property.

Code provided below in case anyone needs this. HTH

Please Login or Register  to view this content.