Module vs porcedure list

[Chris Watts]

My current vba project (for Excel 2007) has about 10 modules containing
around 60 or so procedures. It would be nice to be able to obtain a list of
all these (modules names with procedures that it contains) as a prelude to
doing a little tidying up. Is this possible? I guess that it would need
another vba module to create the list.

Suggestions appreciated.
TIA
Chris

 

[Andy Pope]

Hi,

Try Rob's utility
http://www.appspro.com/Utilities/Documentor.htm

Cheers
Andy

 

[Steve Rindsberg]

My current vba project (for Excel 2007) has about 10 modules containing
around 60 or so procedures. It would be nice to be able to obtain a list of
all these (modules names with procedures that it contains) as a prelude to
doing a little tidying up. Is this possible? I guess that it would need
another vba module to create the list.

http://www.mztools.com/v3/mztools3.aspx

Amazingly useful toolbox for VBA/VB5/VB6

 

[Chris Watts]

My current vba project (for Excel 2007) has about 10 modules containing
around 60 or so procedures. It would be nice to be able to obtain a list
of all these (modules names with procedures that it contains) as a prelude
to doing a little tidying up. Is this possible? I guess that it would
need another vba module to create the list.

Suggestions appreciated.
TIA
Chris

Thanks to Steve and Andy - excellent references.

cheers
Chris