ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Changing Module names (https://www.excelbanter.com/excel-programming/348257-changing-module-names.html)

justaguyfromky

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

Jim Rech

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



Bob Phillips[_6_]

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




Jim Thomlinson[_4_]

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