![]() |
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 |
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 |
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 |
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 |
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 |
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