How can I rename a module in VBA?
 

I cant work out how to rename on of my sub modules?

Does anyone know whether this is possible?

thank

--
CarolineHedge
-----------------------------------------------------------------------
CarolineHedges's Profile: http://www.excelforum.com/member.php...fo&userid=3570
View this thread: http://www.excelforum.com/showthread.php?threadid=55492

How can I rename a module in VBA?
 

In the VBA editor, select your module in the Project Explorer
(CTLR+R to view), press F4 to display the properties window and
change the name there.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"CarolineHedges"
<CarolineHedges.29ur7g_1151061617.0202@excelforu m-nospam.com
wrote in message
news:CarolineHedges.29ur7g_1151061617.0202@excelfo rum-nospam.com...

I cant work out how to rename on of my sub modules?

Does anyone know whether this is possible?

thanks


--
CarolineHedges
------------------------------------------------------------------------
CarolineHedges's Profile:
http://www.excelforum.com/member.php...o&userid=35705
View this thread:
http://www.excelforum.com/showthread...hreadid=554928

How can I rename a module in VBA?
 

Hi Caroline

Are you able to rename the others ? What is different ?

Best wishes Harald

"CarolineHedges"
<CarolineHedges.29ur7g_1151061617.0202@excelforu m-nospam.com skrev i
melding news:CarolineHedges.29ur7g_1151061617.0202@excelfo rum-nospam.com...

I cant work out how to rename on of my sub modules?

Does anyone know whether this is possible?

thanks


--
CarolineHedges
------------------------------------------------------------------------
CarolineHedges's Profile:
http://www.excelforum.com/member.php...o&userid=35705
View this thread: http://www.excelforum.com/showthread...hreadid=554928

How can I rename a module in VBA?
 

Try:

Sub Whats_In_A_Name()
ThisWorkbook.VBProject.VBComponents("Module1").Nam e = "Caroline"
End Sub
--
Gary's Student


"CarolineHedges" wrote:


I cant work out how to rename on of my sub modules?

Does anyone know whether this is possible?

thanks


--
CarolineHedges
------------------------------------------------------------------------
CarolineHedges's Profile: http://www.excelforum.com/member.php...o&userid=35705
View this thread: http://www.excelforum.com/showthread...hreadid=554928

How can I rename a module in VBA?
 

Thanks, it worked perfectly.


--
CarolineHedges
------------------------------------------------------------------------
CarolineHedges's Profile: http://www.excelforum.com/member.php...o&userid=35705
View this thread: http://www.excelforum.com/showthread...hreadid=554928