How to Rename a Module

**makku** · 12-17-2009, 05:35 AM

Is it possible to renumber a module. Example i want to change Module3 to Module2. How can i do it?

regards,

**Domski** · 12-17-2009, 05:58 AM

Make sure you have the properties window open in the VBA Editor (press F4 to view if not) and click on the module. You can then change it's name in the properties window.

Dom

**ncmay** · 12-17-2009, 05:58 AM

Make sure the properties pane is displayed by pressing F4 in the VB Editor.
Activate the Name box and type the desired name.

**Leith Ross** · 12-17-2009, 06:01 AM

Hello makku,

You can change the name of module to whatever you want, as long as you follow these rules: The name must start with and alpha character and can only contain letters, numbers, hyphens, and underscore characters. The length can not be more than 31 characters in length.

To change the module name, click the module you want to change. Go to the "Name" property in the Properties window. If this window is not displayed, press "F4" to display it. Change the name and save your changes.

**Jack in the UK** · 12-17-2009, 08:49 AM

My tip is to name something meaningful and not toooo complex, as your need to find it one day ...

if you read some of my codes Your see i am very careful and name my own way, works for me and i never get mixed up

ie

myColour_CELLS
myMove_IT
my_Split_NAMES

as you see the naming is for the sub routines really, the modules i would tag as

mod_myColour_CELLS
mod_myMove_IT
mod_my_Split_NAMES

Hope that helps and shows what I do to keep things in order, remember done over cook the amount of modules as that’s not a good thing to do so try to ground codes in modules that are related