title: how to get the list of Function and Sub of a given module name in Excel VBA
body: <p>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</p>
  
  <pre><code>Sub Sub1()
  End Sub
  
  Sub Sub2()
  End Sub
  
  Function Func1()
  End Function
  
  Function Func2()
  End Function
  </code></pre>
  
  <p>Is there a command or routine that can return the list of Function and Sub names?</p>