CODEWITHSUNDEEP
vbaexcel
SMir
SMir

Reputation: 660

list of procedures called in vba

Is there an easy way to extract/document the list of the procedures/functions that are called when a VBA project is run? Just to clarify, the VBA project handles several algorithms, and each algorithm uses/calls only a specific set of procedures/functions within the VBA project.

NOTE: One way I achieved this was to use the extensibility library to programmatically add a single line to each procedure/function that would append the name of the respective procedure/function to a text file. But after doing that my Excel installation started complaining about my VBA project (Add-in). So I am looking for alternative ways.

Thanks.

Upvotes: 0

Views: 767

Answers (1)

Mawia
Mawia

Reputation: 4310

Put a code in each procedures/functions that will store some values in a sheet or somewhere else.

Upvotes: 1

Related Questions