![]() |
Changing Module names
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 |
Changing Module names
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 |
Changing Module names
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 |
Changing Module names
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 |
All times are GMT +1. The time now is 12:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com