Diagrams for Analysis of VBA

drewg

Board Regular
Joined
Jul 5, 2010
Messages
67
Does anyone know of EXCEL VBA freeware (not visio, not commercial) that goes through your VBA Project and documents the call stack with whatever object types, names and signitures it happens to encounter after Activate, and then, since its not possible to tell what a user will do next, at least acknowledge and catalog the existence of a Sub or Function in a Module,Form,Worksheet,NamedRange/NamedFormula...I must have missed a few, and annotates which other data types, objects, subs or functions it uses or is used by?

I started working on a project, thought ok, spawn as many modules as you need, collect like minded subs by affinity either by function or by data and go from there. Paradoxically, organization broadens your scope, and the next thing you know your three modules are 12, and one of them is named BoulevardOfBrokenDreams.

Know of a freebie Excel based diagrammer app for systems analysis of VBA?
Thanks very much in advance.
 
Last edited:

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Watch MrExcel Video

Forum statistics

Threads
1,090,055
Messages
5,412,091
Members
403,411
Latest member
aspofford

This Week's Hot Topics

Top