LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default 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











 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CLASS MODULE & SIMPLE MODULE FARAZ QURESHI Excel Discussion (Misc queries) 1 September 7th 07 09:32 AM
code in module A to not execute a Worksheet_SelectionChange sub of another module Jack Sons Excel Discussion (Misc queries) 4 December 11th 05 11:52 PM
Renaming a standard module Todd Huttenstine[_2_] Excel Programming 5 December 31st 03 10:49 PM
Variable from a sheet module in a class module in XL XP hglamy[_2_] Excel Programming 2 October 14th 03 05:48 PM
Renaming VBA module Avner Mediouni Excel Programming 2 August 25th 03 12:27 PM


All times are GMT +1. The time now is 11:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"