Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 43
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,718
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default 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



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,119
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Set Worksheet Names in a Module Noemi Excel Discussion (Misc queries) 1 July 20th 06 01:39 PM
Macro names in a Module [email protected] Excel Programming 7 July 28th 05 05:12 PM
Changing VB Component Names to match Worksheet names using VBE Philip Excel Programming 1 April 12th 05 05:37 PM
Module Names within a Project WSF Excel Programming 2 May 15th 04 11:51 PM
Module Names Casey[_2_] Excel Programming 4 January 6th 04 11:03 PM


All times are GMT +1. The time now is 10:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"