Excel VBA Code Management - Big Project

[bobo999]

I am writing a quite big project in excel vba, as an xlam which will be added to various user's machines.

The code has grown to a point where it has 20 or so modules, numerous forms, organized by type of function and use, however there are still about 30-40 subroutines, functions, in total, which are difficult for me to locate at any given time, when wanting to go edit code, etc.

What software can help me manage this project as it will only continue to grow. To be more specific I am looking for a top level view of all my functions, and subroutines, being able to locate them quickly, to go edit. Version control isn't really my goal, it's to be able to manage all the functions, quickly being able to switch from one function to another without having to remember whether I had put Function87 in module86 or module 87.

Hope someone can help out!

Thanks!

 

[Jeffrey Lopez]

Someone else might have another suggestions, but I would HIGHLY recommend going back though your code and renaming things to something more coherent than Function87, module86,module 87 or any other generic naming convention. This will not only cause problems for you, but it will cause problems for anyone else that has to do any work with that code. Nothing erks me more then when someone leaves the company and I am stuck trying to decipher their macros and they use generic names like that...

Also by doing this it will allow you to use a simple text editor to flip though your code looking for what needs to be updated... and if you have your mods/funs named in a coherent way, they will much easier to go though... here is a screen shot of what it might look like using Notepad++

By keeping your names something easy to follow and by formatting your macros with the proper white space, will allow others and even yourself, to better follow your code. It will also help with debugging if some cases... Here is an article that discusses more in-depth the importance of formatting your code properly..

Formatting Code

 

[bobo999]

Thanks for the response. My functions are named very appropriately and all commented heavily, intended etc! I was just using an example of function87 but they all have very indicative names.

Thanks for the notepad++ idea, is there any other methods ?