Excel VBA: How To: Set Custom Module Name [RESOLVED]
Esteemed Forum Participants and Lurkers:
===============================
Excel 2003 VBA
Is it possible to give a Module in a VBA project a CUSTOM NAME? Excel just seems to blindly assign "Module" followed by a sequence number. I would like to put a descriptive name on a module in a project that I am sharing with other developers.
Re: Excel VBA: How To: Set Custom Module Name ???
Create your module
Open Properties
Change the Name (no spaces tho - I think it is almost a filename!)
Save
Re: Excel VBA: How To: Set Custom Module Name ???
Thanks Vince ...
I am so used to doing a Right-Click on a tree branch name to get to properties that I didn't stop to think that it has to be done a different way in the VB Editor.
It took a minute or two to find the magic sequence in the VB Editor window:
View > Properties Window: Alphabetic: Name
Thanks for the help!