Renaming VBA Modules

C

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
 
F

Frank Kabel

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

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to use modules so that values calculated in one of them can beused by another? 1
Module Name 2
renaming VBA "modules" 4
remove module via code 2
Excel 2003 - VBA to get a list of Module names in the project 4
Accessing Public variable in different modules 6
My VBA Project Explorer quit listing modules and worksheets separa 1
Shortcuts for VBA procedures in Modules of MS Access 5

Top