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: 208
excel-vba
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