Results 1 to 3 of 3

Thread: Excel VBA: How To: Set Custom Module Name [RESOLVED]

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    May 2004
    Location
    Carlisle, PA
    Posts
    1,045

    Resolved 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

  2. #2
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    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

    BOFH Now, BOFH Past, Information on duplicates

    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...

  3. #3

    Thread Starter
    Frenzied Member
    Join Date
    May 2004
    Location
    Carlisle, PA
    Posts
    1,045

    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
  •  



Click Here to Expand Forum to Full Width