| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
renaming VBA "modules"
I’m running XL97 under WinXP-pro. Associated with an XL97 workbook are
numerous macros in various “modules” in a VBA Project. Some of these “modules” have informative names while others are merely named Module1, or Module2. I’m not sure how some ended up with appropriate names while the others simply have a generic title. Is there a way to change these module names? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
renaming VBA "modules"
Hi Windsurfer,
Select the module in the explorer window (Ctrl-R), open the properties window (F4) and change the module's name property. --- Regards, Norman "windsurferLA" wrote in message . .. I’m running XL97 under WinXP-pro. Associated with an XL97 workbook are numerous macros in various “modules” in a VBA Project. Some of these “modules” have informative names while others are merely named Module1, or Module2. I’m not sure how some ended up with appropriate names while the others simply have a generic title. Is there a way to change these module names? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
renaming VBA "modules"
Thanks.... works
Norman Jones wrote: Hi Windsurfer, Select the module in the explorer window (Ctrl-R), open the properties window (F4) and change the module's name property. --- Regards, Norman "windsurferLA" wrote in message . .. I’m running XL97 under WinXP-pro. Associated with an XL97 workbook are numerous macros in various “modules” in a VBA Project. Some of these “modules” have informative names while others are merely named Module1, or Module2. I’m not sure how some ended up with appropriate names while the others simply have a generic title. Is there a way to change these module names? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
renaming VBA "modules"
Or you can select a module (in the Project Explorer), press F4 on your
keyboard twice. Then type a new name. It's always a good idea to give the modules consistent descriptive names. Regards, Edwin Tam http://www.vonixx.com "windsurferLA" wrote: Im running XL97 under WinXP-pro. Associated with an XL97 workbook are numerous macros in various €śmodules€ť in a VBA Project. Some of these €śmodules€ť have informative names while others are merely named Module1, or Module2. Im not sure how some ended up with appropriate names while the others simply have a generic title. Is there a way to change these module names? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
renaming VBA "modules"
Thanks ... works... it is obvious now that I see what to do.
Edwin Tam wrote: Or you can select a module (in the Project Explorer), press F4 on your keyboard twice. Then type a new name. It's always a good idea to give the modules consistent descriptive names. Regards, Edwin Tam http://www.vonixx.com "windsurferLA" wrote: Im running XL97 under WinXP-pro. Associated with an XL97 workbook are numerous macros in various €śmodules€ť in a VBA Project. Some of these €śmodules€ť have informative names while others are merely named Module1, or Module2. Im not sure how some ended up with appropriate names while the others simply have a generic title. Is there a way to change these module names? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| VBE - Possible to have one of five modules in a VB project to be "default"? | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| "Static" Methods in Class Modules | Excel Programming | |||
Hybrid Mode
