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?

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?

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?

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?

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?