Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would like to give a name to all of my modules because I have over 60 of
them and it is starting to get confusing finding the one I want because I cant remember the module number. Any ideas??? Thanks |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
To rename the active module just open the Properties window (press F4) and
change its name there. -- Jim "justaguyfromky" wrote in message ... |I would like to give a name to all of my modules because I have over 60 of | them and it is starting to get confusing finding the one I want because I | cant remember the module number. Any ideas??? | | Thanks |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
For what? Whether to do it? Yes! What to call them? Only you know what they
do. Too many? Probably. Too much code? If you have 60 very big modules, probably. If 60 with very little code in each, probably better to group some of them. -- HTH RP (remove nothere from the email address if mailing direct) "justaguyfromky" wrote in message ... I would like to give a name to all of my modules because I have over 60 of them and it is starting to get confusing finding the one I want because I cant remember the module number. Any ideas??? Thanks |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
60 is a lot of modules. I am not saying it is wrong just that it is a lot...
You should consider grouping some of the code as Bob suggested. You can change the module names a Jim suggests, the only caveat bieng if in any of your module you have explicitly reference one of the other modules then you will need to manually chage the reference. For example if in module 2 you called a sub from module 1 like this Call Module1.Mysub() then you have to manually change this lien of code to reflect the new name you have given the module. Finally just for consistency it is standard practice to start all of your module names with either mod or m such as modFileFunctions or mFileFunctions -- HTH... Jim Thomlinson "justaguyfromky" wrote: I would like to give a name to all of my modules because I have over 60 of them and it is starting to get confusing finding the one I want because I cant remember the module number. Any ideas??? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Set Worksheet Names in a Module | Excel Discussion (Misc queries) | |||
Macro names in a Module | Excel Programming | |||
Changing VB Component Names to match Worksheet names using VBE | Excel Programming | |||
Module Names within a Project | Excel Programming | |||
Module Names | Excel Programming |