Renaming VBA Modules

[cogent]

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]

Hi
in the VBA editor try the following:
- select the module
- hit F4
- change the module name

 

[Bob Phillips]

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)