title: Parsing VBA Module function parameters via reflection
body: <p>In Excel, I have a VBA module called <code>MyModule</code> which has a function as such</p>
  
  <pre class="lang-vb prettyprint-override"><code>    Public Function MyFunction(Param1 As Range, Param2 As Range) As String
              ' some implementation
      End Function
  </code></pre>
  
  <p>At runtime, I know that I have a module called <code>MyModule</code> and I know I have a function called <code>MyFunction</code> but I want to inspect dynamically the parameter names <code>Param1</code> and <code>Param2</code></p>
  
  <p>In my world (C#), this is called reflection. Can I use similar concepts here to get the parameter name or am I expecting too much from VBA?</p>