ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Renaming a Module (https://www.excelbanter.com/excel-programming/322093-renaming-module.html)

Robert Christie[_3_]

Renaming a Module
 
Hi
I was looking at the code in Rob Bovey's VBACodeDocumentor.xla and noticed
Rob had given each Module an individual & distinctive name i.e.MStandardCode,
MEntryPoints etc..
Can this Module renaming/naming be carried out in MS Office XP 2003
Professional?
If so how?

TIA.
--
Thank you

Regards
Aussie Bob C.
Using Windows XP Home + Office 2003 Pro

R.VENKATARAMAN

Renaming a Module
 
when you are in a module click function key F4 and you get property window.
change the name and hit enter.


Craig wrote in message
...
Yes it can
Use the properties window

Craig

"Robert Christie" wrote in message
...
Hi
I was looking at the code in Rob Bovey's VBACodeDocumentor.xla and

noticed
Rob had given each Module an individual & distinctive name

i.e.MStandardCode,
MEntryPoints etc..
Can this Module renaming/naming be carried out in MS Office XP 2003
Professional?
If so how?

TIA.
--
Thank you

Regards
Aussie Bob C.
Using Windows XP Home + Office 2003 Pro







Robert Christie[_3_]

Renaming a Module
 
Thanks Craig
Are there any hidden gotches I should no about. i.e. same name as a
procedure or sheet tab name?

Regards Aussie Bob C.

"Craig" wrote:

Yes it can
Use the properties window

Craig

"Robert Christie" wrote in message
...
Hi
I was looking at the code in Rob Bovey's VBACodeDocumentor.xla and noticed
Rob had given each Module an individual & distinctive name

i.e.MStandardCode,
MEntryPoints etc..
Can this Module renaming/naming be carried out in MS Office XP 2003
Professional?
If so how?

TIA.
--
Thank you

Regards
Aussie Bob C.
Using Windows XP Home + Office 2003 Pro





Robert Christie[_3_]

Renaming a Module
 
Thanks R. Ve.
Are there any hidden gotches I should no about. i.e same name as a procedure
or sheet tab name?

Regards Aussie Bob C.

"R.VENKATARAMAN" wrote:

when you are in a module click function key F4 and you get property window.
change the name and hit enter.


Craig wrote in message
...
Yes it can
Use the properties window

Craig

"Robert Christie" wrote in message
...
Hi
I was looking at the code in Rob Bovey's VBACodeDocumentor.xla and

noticed
Rob had given each Module an individual & distinctive name

i.e.MStandardCode,
MEntryPoints etc..
Can this Module renaming/naming be carried out in MS Office XP 2003
Professional?
If so how?

TIA.
--
Thank you

Regards
Aussie Bob C.
Using Windows XP Home + Office 2003 Pro








Myrna Larson

Renaming a Module
 
You will save yourself grief if you use names differ from those of procedures
and sheets.

On Mon, 31 Jan 2005 22:05:02 -0800, Robert Christie
wrote:

Thanks R. Ve.
Are there any hidden gotches I should no about. i.e same name as a procedure
or sheet tab name?

Regards Aussie Bob C.

"R.VENKATARAMAN" wrote:

when you are in a module click function key F4 and you get property window.
change the name and hit enter.


Craig wrote in message
...
Yes it can
Use the properties window

Craig

"Robert Christie" wrote in message
...
Hi
I was looking at the code in Rob Bovey's VBACodeDocumentor.xla and

noticed
Rob had given each Module an individual & distinctive name
i.e.MStandardCode,
MEntryPoints etc..
Can this Module renaming/naming be carried out in MS Office XP 2003
Professional?
If so how?

TIA.
--
Thank you

Regards
Aussie Bob C.
Using Windows XP Home + Office 2003 Pro








Bob Phillips[_6_]

Renaming a Module
 
Always wise to have a unique prefix for such objects, such as m for modules,
frm for userforms, cls for classes etc.

Ditto for controls, such as textboxes, buttons.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Myrna Larson" wrote in message
...
You will save yourself grief if you use names differ from those of

procedures
and sheets.

On Mon, 31 Jan 2005 22:05:02 -0800, Robert Christie
wrote:

Thanks R. Ve.
Are there any hidden gotches I should no about. i.e same name as a

procedure
or sheet tab name?

Regards Aussie Bob C.

"R.VENKATARAMAN" wrote:

when you are in a module click function key F4 and you get property

window.
change the name and hit enter.


Craig wrote in message
...
Yes it can
Use the properties window

Craig

"Robert Christie" wrote in

message
...
Hi
I was looking at the code in Rob Bovey's VBACodeDocumentor.xla and
noticed
Rob had given each Module an individual & distinctive name
i.e.MStandardCode,
MEntryPoints etc..
Can this Module renaming/naming be carried out in MS Office XP 2003
Professional?
If so how?

TIA.
--
Thank you

Regards
Aussie Bob C.
Using Windows XP Home + Office 2003 Pro











All times are GMT +1. The time now is 05:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com