Hi all,
This might be an odd question and equally impossible.
I have an entire list of modules running in my vba interface. Is it at all possible to add extra folders just to have a bit more organised look in my vba?
Hi all,
This might be an odd question and equally impossible.
I have an entire list of modules running in my vba interface. Is it at all possible to add extra folders just to have a bit more organised look in my vba?
Last edited by Jacques Grobler; 06-14-2011 at 04:38 AM.
Jacques
are the modules all in one workbook?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Hi Roy,
They are all in an addin.
I don't believe you can add further folders beyond the Excel Objects, Forms, Modules and class ones.
How many module objects do you have?
Currently in the order of 12, but I'm still busy with my developement and believe that this will increase as time goes by.
If I cannot add folders, is there a way to better manage my modules/code for navigation? I'm still a bit new to programming and dont programme everyday, so I'm not to aware of GOOD or effective programming practices...
I guess the first question is why 12 modules? You do not have to have a separate module for each macro.
It is because I have each module containing equations or procedures pertaining to different aspects.
All general maths in one, company specific maths in the next, etc etc etc...
so it sounds as if you have your code as organised as it can be.
Just thought as there are some brighter minds and better trained minds than mine, I might get some good tips...
Thanks anyway
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks