Renaming Modules in VBA

[zakasnak]

So I know HOW to rename the modules, based on the various results of my search.

What I want to know is what is the best way to rename. I feel kind of limited since the macro is named, after SUB, what I want to name it, already, but...

I've kind of figured out NOT to name it the same as what comes after SUB in the macro. I ended up with compile errors & the code required me to rename my calls to macro_name.macro_name. Wouldn't the same thing happen if I were to name the module "MacroName" while the macro itself, after SUB, was named "macro_name"? If not, then why not?

Thanks for your help!

 

[KGee]

For modules with only one sub-routine I usually follow this convention:

Module Name:
Print_Sales_Chart

Sub Name:
PrintSalesChart

That's just the way I've been doing it but I don't think there is a "right" way, other than the fact they cannot have the same name. Coming up with a standard that is easy to follow and being consistent is more important. I'm sure others will have their own thoughts too.