VBA Code Analysis Cross-Reference Tool?

[chucklod]

Is there a VBA cross-reference program anywhere?
I'm looking for one that references all of a VBA module's subroutine names, variable names, line numbers, declarations (if any)... I'm working in Excel 2011, but I'm sure one for Word or another version would be satisfactory.
Or must I write my own?

Thanks,
Chuck

[6StringJazzer]

I found this code that will list all procedures. If you don't find something that will list variables I might be interested in helping to write it. It's not hard to list declared variables but finding undeclared variables requires an effort tantamount to writing a VBA parser.

Also I'm kind of wondering about the "...".

https://www.vitoshacademy.com/vba-li...n-all-modules/

Please Login or Register  to view this content.

[6StringJazzer]

I've been dribbling this out since October. Hopefully you will find it helpful. I'm not completely done but this has most of what you described (no line numbers).

First you must open the .xlsm file you want to analyze. Then click the button on Control and select the desired VBA project.