![]() |
Renaming VBA Modules
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 |
Renaming VBA Modules
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 |
Renaming VBA Modules
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 |
All times are GMT +1. The time now is 02:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com