VBE Module Names
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
|