Oct 04 2021 06:33 AM
Are there any VBA methods similar to Python methods like globals(), locals(), dir() and even help() which allow you to inspect and learn more about VBA methods programmatically or from the immediate pane, for example? I.e., to print a list of arguments that some given method takes, or the methods of a class?
Thank you very much.
Oct 04 2021 06:47 AM
See:
The Code Documentor (free; Excel only)
Code Documenter (free; requires that you have Microsoft Access; works with Access, Excel, PowerPoint and Word)
https://www.mztools.com/ (paid; for VBA, VB5, VB6 and Visual Studio)
Oct 04 2021 07:43 AM
Oct 04 2021 07:48 AM
The first and third one are add-ins in the Visual Basic Editor; they add new menu options.
The second one is an Access database with forms to let you specify what you want to document.
Oct 04 2021 07:54 AM
Oct 04 2021 07:57 AM
I cannot help you with that, sorry.