|
-
May 31st, 2006, 08:00 AM
#1
Thread Starter
Frenzied Member
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.
Last edited by Webtest; May 31st, 2006 at 01:24 PM.
Blessings in abundance,
All the Best,
& ENJOY!
Art . . . . Carlisle, PA . . USA
-
May 31st, 2006, 09:24 AM
#2
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
Feeling like a fly on the inside of a closed window (Thunk!)
If I post a lot, it is because I am bored at work! ;D Or stuck...
* Anything I post can be only my opinion. Advice etc is up to you to persue...
-
May 31st, 2006, 01:24 PM
#3
Thread Starter
Frenzied Member
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!
Blessings in abundance,
All the Best,
& ENJOY!
Art . . . . Carlisle, PA . . USA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|