VBA get all subroutines, functions, class properties

Posted on 2011-04-27
Last Modified: 2012-05-11
I have an excel macro with large number of modules / class modules, forms.

I want to write a macro to get list of all sub routines, functions, properties from;
Modules, Forms, Class Modules, Thisworkbook, worksheet modules for that excel macro

How do I go forward to get this working?
Question by:cynx
    LVL 85

    Accepted Solution

    Have you tried the code documenter add-in from here:
    LVL 30

    Assisted Solution

    cynx, In case you are interested in the how to do it yourself then see this link by Chip Pearson.

    Topic: Programming The VBA Editor


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
    Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now