renaming VBA "modules"

W

windsurferLA

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

Norman Jones

Hi Windsurfer,

Select the module in the explorer window (Ctrl-R), open the properties
window (F4) and change the module's name property.
 
E

Edwin Tam

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
(e-mail address removed)
http://www.vonixx.com
 
W

windsurferLA

Thanks.... works

Norman said:
Hi Windsurfer,

Select the module in the explorer window (Ctrl-R), open the properties
window (F4) and change the module's name property.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top