Changing Module name

[Daminc]

Hi everyone,

Is it possible to change the name of a Module within a project?

e.g.
Module1 = Subroutines
Module2 = Functions

I can't find a way to do this and I would like to know whether to stop
looking

 

[Bob Phillips]

G into the VBIDE (Alt-F11)
press F4 to make the properties window visible
click your module name
in the properties window, change the (Name) property to your value

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[mudraker]

Daminic

Yes you can rename modules

In Visual Basic Editor
Press F4 - this open the Properties Window if it is not already open
Click on the Module that you want to re-name
This will display the module name int he property window
Higlight module name and overtype the name with your required name.

Just remember renaming modules may cause problems if you have a
worksheet or workbook with the same name or you use a name that excel
has restricted for its own use. Also some charactors are not allowed
like spaces

module name of Function is not allowed but Functions is

 

[Daminc]

Excellent

I doubt that I would have found that in a long time...if ever.

Thank you very much for that bit of info