VBE Module Names

[Bill Martin]

Is there a way to assign names to VBE code modules? VBE defaults them to
Module1, Module2, etc. which isn't as helpful as real names would be.

Buried in the Help system, to resolve a problem I see that it tells me to
"Change the module name..." which leads me to believe/hope that there is a way
to do this. Unfortunately I can't convince Help to actually tell me how to do it.

Thanks.

Bill

 

[JNW]

In VBA press "F4" to open the properties then change the name. Don't know
about VBE.

 

[Jim Thomlinson]

VBE is just Visual Basic Environment. I have also heard it as Visual Basic
Explorer. VBIDE is Visaul Basic Integrated Developement Environment.

 

[Dave Peterson]

I've heard/typed: "Visual Basic Editor", too.

And just a reminder. Try to make the module names different from the
subroutine/function names. Excel can get confused if you reuse names like that.

 

[Bill Martin]

FWIW, Walkenbach also claims VBE is "Visual Basic Editor" which is probably
where I picked it up. And here's a line from the Excel help system:

"... a VBE object that represents the Visual Basic Editor... "

Bill
---------------------------------

 

[Bill Martin]

That does the trick! Thanks for the help.

Bill
-----------------