ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Renaming VBA Modules (https://www.excelbanter.com/excel-programming/294188-renaming-vba-modules.html)

cogent

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



Frank Kabel

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




Bob Phillips[_6_]

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