how to get the list of Function and Sub of a given module name in Excel VBA
- by Kratz
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?
