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

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

"Bill Martin" wrote:

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

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

Jim Thomlinson


"JNW" wrote:

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

"Bill Martin" wrote:

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

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.



JNW wrote:

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

"Bill Martin" wrote:

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


--

Dave Peterson

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
---------------------------------
Dave Peterson wrote:
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.



JNW wrote:

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

"Bill Martin" wrote:


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

That does the trick! Thanks for the help.

Bill
-----------------
JNW wrote:
In VBA press "F4" to open the properties then change the name. Don't know
about VBE.

"Bill Martin" wrote:


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