Renaming modules

[Guest]

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.

 

[Guest]

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).

 

[Gord Dibben]

Left-click on the module to select.

View>Properties Window(or F4)

Change the name here.


Gord Dibben MS Excel MVP

 

[Guest]

Jim - Thanks!
Bob

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).

 

[Guest]

Gord - Thanks!
Bob

Left-click on the module to select.

View>Properties Window(or F4)

Change the name here.


Gord Dibben MS Excel MVP