View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bill Martin[_2_] Bill Martin[_2_] is offline
external usenet poster
 
Posts: 105
Default 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