| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i rename a sheet if the rename tab is inactive? | Excel Worksheet Functions | |||
| Rename a module | Excel Programming | |||
| Calls from sheet module to ThisWorkbook module | Excel Programming | |||
| can you rename a module? | Excel Discussion (Misc queries) | |||
| Rename Module | Excel Programming | |||
![CarolineHedges[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
