how to get the list of Function and Sub of a given module name in Excel VBA

Posted by Kratz on Stack Overflow See other posts from Stack Overflow or by Kratz
Published on 2010-04-13T15:31:17Z Indexed on 2010/04/13 15:33 UTC
Read the original article Hit count: 212

Filed under:

I am working on a helper macro that look into the list function on a given module name on the active excel workbook. Ex: I have a module name "Module1". Inside this module has the following function or sub

Sub Sub1()
End Sub

Sub Sub2()
End Sub

Function Func1()
End Function

Function Func2()
End Function

Is there a command or routine that can return the list of Function and Sub names?

© Stack Overflow or respective owner

Related posts about excel-vba