List Procedures (Subs's, Functions and Parameters)

[JCabral]

Hi

With the help of Mathieu Guindon and the site http://www.cpearson.com/Excel/MainPage.aspx, I was able, by copying and pasting some subroutines, to have a list of all existing procedures (Sub's and Functions, with the parameters) in the various modules of my application.



As I said, I just copied and pasted the subroutines, I don't know how to clean up all the "junk" that doesn't matter in the code and make the code cleaner.



Another thing I was unable to do was write at the beginning of each module, which procedures the module contains, that is, instead of listing the procedures of each module on a spreadsheet, I would like to list at the beginning of each module.



So the help I ask for is:

1) Help to clean the code, making it as clean as possible;

2) Possibility to write the respective existing procedures directly on each module. (As the picture shows)
Img1.png



The attached file lists all procedures on a spreadsheet,

Thank you

Jorge

PS: Also in : https://www.ozgrid.com/forum/index.p...nd-parameters/

[gue2013]

the change part in RED shows the addon. All code related to worksheet output I changed to comments
There is also a check inside which prevents to add the same stuff a second time.
If you later add or change a procedure you have to remove the description first

Please Login or Register  to view this content.

[JCabral]

the change part in RED shows the addon. All code related to worksheet output I changed to comments

Great!

There is also a check inside which prevents to add the same stuff a second time.

Fantastic!

If you later add or change a procedure you have to remove the description first

Perfect!


You just have done what a lot of people say that is not possible.

Thank you so much
Jorge Cabral

[gue2013]

welcome

[paperfold]

I've found this very interesting and useful. Thank you.

[JCabral]

I've found this very interesting and useful. Thank you.

It is curious because it seems that there are only two of us who find this interesting and useful.
Fortunately gue2013 solved the problem