What subroutines are called from a subroutine

Good afternoon


Is it possible to know for each subroutine that exists in a given Module what subroutines // function of the global project are called, within that subroutine?

If so, how to do it?


I hope I have been clear in my doubt.

Thanks

Jorge Cabral

It can be done using VBE.

Prerequisite - VBE must be enabled - see March 26, 2012 post by Siddharth Rout: https://stackoverflow.com/questions/...ogrammatically

Chip Pearson was kind enough to leave us the tools at http://www.cpearson.com/excel/vbe.aspx

Take a look at Chip's sections on:
a. Listing All Procedures In A Module
b. Searching For Text In A Module

It's a lot of work, but it can be done.

Enjoy.

Lewis

Hi Lewis

Thank you very much for your reply.

The problem, for me, is not about too much work, but knowledge, and mine is very, very basic.
When I asked here on the forum, I sincerely thought it was a quick answer, because it is a type of tool that helps a lot to see the flow in a program. And for those who are studying a program it is very useful.

I quickly realized that it is very complicated, and then for me it is much more complicated.

Let's see if during this very difficult period that we are all going through, someone sets up a little time to develop this routine.

Thank you very much
Stay safe, stay home
Jorge