Renaming modules

B

Bob

Is there a way I can rename Module1, Module2, etc. to something more
meaningful? I have right-clicked on the module name and looked through all
of the VBE menus, but I can't seem to find an option to change a module's
name.
Any help would be greatly appreciated. Thanks.
 
J

Jim Thomlinson

Bring up the properties window (F4) if it is not already open. The first Itme
is name and this is where you can change the module name. FYI the standard
prefix is mod so in general you may want to name your modules starting with
that prefix (modPrintRoutines for example).
 
G

Gord Dibben

Left-click on the module to select.

View>Properties Window(or F4)

Change the name here.


Gord Dibben MS Excel MVP
 
B

Bob

Jim - Thanks!
Bob


Jim Thomlinson said:
Bring up the properties window (F4) if it is not already open. The first Itme
is name and this is where you can change the module name. FYI the standard
prefix is mod so in general you may want to name your modules starting with
that prefix (modPrintRoutines for example).
Click to expand...
 

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
remove module via code 2
Changed module names don't register in toolbar links 2
Accessing Public variable in different modules 6
NAMING OF A MODULE AND MAKING IT UNOBSERVABLE - VERY BASIC 5
How can we rename modules? 4
renaming VBA "modules" 4

Top