Do module name changeable?
 

Do module name changeable?

In excel Visual Basic Editior, whenever a new module is added, the
module is named in the way:
module1
module2
module3
...
Can the module name be changed? (eg. module1--test)



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Do module name changeable?
 

In the VBA editor select "Properties" (F4) and make the
change under (Name).


-----Original Message-----
Do module name changeable?

In excel Visual Basic Editior, whenever a new module is
added, the
module is named in the way:
module1
module2
module3
...
Can the module name be changed? (eg. module1--test)



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/

.

Do module name changeable?
 

press F4 to open the properties window. Click on the module in question,
change the name in the properties window.

--
Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in


"active_x" wrote in message
...
Do module name changeable?

In excel Visual Basic Editior, whenever a new module is added, the
module is named in the way:
module1
module2
module3
..
Can the module name be changed? (eg. module1--test)



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/