Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modules
Hi Everyone:
I was wondering if in the VBA section of excel 2003, there is a way to create folders, so that I can organize my modules. For example if I have 9 modules in my project, I want to create 2 folders, one containing 3 modules, and the other the rest of the modules (6 modules). Thanks for your help. Bob |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modules
there is a way to create folders
No there isn't. The best you can do I think is to name of modules you want to keep together similarly since Excel lists them alphabetically. -- Jim "Bob" wrote in message ... Hi Everyone: I was wondering if in the VBA section of excel 2003, there is a way to create folders, so that I can organize my modules. For example if I have 9 modules in my project, I want to create 2 folders, one containing 3 modules, and the other the rest of the modules (6 modules). Thanks for your help. Bob |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modules
I often name modules with a single lowercase letter followed by the module
name beginning with an uppercase letter. Example: aPublicDefs bInitialization cFunctions dGeometry eEtc That "groups" them as I desire and orders them in a way that makes sense to me. Since I do not use the module names in the code, it is easy to insert a new module by just changing the 1st letters of the modules that follow. On Sun, 7 Sep 2008 20:54:23 -0400, "Jim Rech" wrote: there is a way to create folders No there isn't. The best you can do I think is to name of modules you want to keep together similarly since Excel lists them alphabetically. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Public, Private, Event modules, Forms modules,,, | Excel Programming | |||
Basic question - modules and class modules - what's the difference? | Excel Programming | |||
When to code in sheet or userform modules and when to use modules | Excel Programming | |||
modules | Excel Programming | |||
Class Modules vs Modules | Excel Programming |