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
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
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)
"Daminc" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> Daminc
> ------------------------------------------------------------------------
> Daminc's Profile:
http://www.excelforum.com/member.php...o&userid=27074
> View this thread: http://www.excelforum.com/showthread...hreadid=534914
>
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
Excellent
I doubt that I would have found that in a long time...if ever.
Thank you very much for that bit of info.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks