Renaming a standard module

T

Todd Huttenstine

Hey guys

how do I manually rename a standard module? I have allot
of modules with the naming scheme
of "Module1", "Module2", "Module3" and so on...

Thanx

Todd Huttenstine
 
H

Harald Staff

Hi Todd

Do that in the Propeties window, (Name) field, down left in the VBE (or
display it with the View menu if absent).

And get yourself a stiff new years drink -bet you deserve a couple after
this week's activity ;-)
 
B

Bob Phillips

Todd,

Don't forget to rename the projects as well.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
T

Todd Huttenstine

Thanks Harald. Your right, I'd much rather prefer
spending my time New Years with a few drinks than VBA.

:) thanks again

Todd
 
J

John Wilson

Todd,

To add to the excellent advice that you've already been given...
It's not a good idea to name a module with the same name
as a sub within that module.
Can cause a lot of headaches.

John
 
H

Harald Staff

I've spent far too much time repairing my own lousy code written at times
where I was too exhausted to work properly. Nowadays I never ever work more
than 12 hours on any day, no matter how long ago the deadline might have
been. There's zero quality to my work after that so it just isn't worth it.

But I'm old. My capacity was different in my twenties. Or perhaps I just
like to think it was :) Happy new year !

Best wishes Harald
Followup to newsgroup only please
 

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

Similar Threads


Top