Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Renaming modules
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Renaming modules
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). -- HTH... Jim Thomlinson "Bob" wrote: 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Renaming modules
Left-click on the module to select.
ViewProperties Window(or F4) Change the name here. Gord Dibben MS Excel MVP On Tue, 11 Sep 2007 08:26:05 -0700, Bob wrote: 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Renaming modules
Jim - Thanks!
Bob "Jim Thomlinson" wrote: 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). -- HTH... Jim Thomlinson "Bob" wrote: 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Renaming modules
Gord - Thanks!
Bob "Gord Dibben" wrote: Left-click on the module to select. ViewProperties Window(or F4) Change the name here. Gord Dibben MS Excel MVP On Tue, 11 Sep 2007 08:26:05 -0700, Bob wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
renaming VBA "modules" | Excel Programming | |||
Public, Private, Event modules, Forms modules,,, | Excel Programming | |||
Basic question - modules and class modules - what's the difference? | Excel Programming | |||
Renaming modules | Excel Programming | |||
Renaming VBA Modules | Excel Programming |