Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello
In Project Explorer view in the VBA window, I have seven Modules of code. Often when I am looking for a specific procudure it is difficult to find because I cannot figure out how to ReName the Modules. Does anyine know how I can rename the Modules from Module1, Module2... etc to (text) names that are more cognitive. Thank you in advance. W |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
in the VBA editor try the following: - select the module - hit F4 - change the module name -- Regards Frank Kabel Frankfurt, Germany "cogent" schrieb im Newsbeitrag ... Hello In Project Explorer view in the VBA window, I have seven Modules of code. Often when I am looking for a specific procudure it is difficult to find because I cannot figure out how to ReName the Modules. Does anyine know how I can rename the Modules from Module1, Module2... etc to (text) names that are more cognitive. Thank you in advance. W |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In the VBE, in the Project Explorer window (Ctrl-R), select the module you
want to rename, then goto the Properties window (F4), and you will see the name property there. Just over-type it. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "cogent" wrote in message ... Hello In Project Explorer view in the VBA window, I have seven Modules of code. Often when I am looking for a specific procudure it is difficult to find because I cannot figure out how to ReName the Modules. Does anyine know how I can rename the Modules from Module1, Module2... etc to (text) names that are more cognitive. Thank you in advance. W |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VB Modules | Excel Discussion (Misc queries) | |||
Help with modules. | New Users to Excel | |||
modules | Excel Programming | |||
Forms and Modules | Excel Programming | |||
Class Modules vs Modules | Excel Programming |