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?

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" <[email protected]> wrote in message
news:[email protected]...
> 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?

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
[email protected]
http://www.vonixx.com



"windsurferLA" wrote:

> 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?
>

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" <[email protected]> wrote in message
> news:[email protected]...
>
>>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?
>
>
>

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
> [email protected]
> http://www.vonixx.com
>
>
>
> "windsurferLA" wrote:
>
>
>>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?
>>