Renaming a standard module

[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

 

[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 ;-)

 

[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)

 

[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

 

[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

 

[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