+ Reply to Thread
Results 1 to 6 of 6

How do I change Module Names

  1. #1
    Registered User
    Join Date
    05-29-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    84

    How do I change Module Names

    How do I either update my modules or change some setting to get my macros to show up with the name of the macro rather than "Module 1" when viewing the VBA editor? I figured it would be something like right clicking and choosing "rename" but that isn't an option. I have a couple macros I imported from someone else which are listing with the macro name.

  2. #2
    Valued Forum Contributor rollis13's Avatar
    Join Date
    01-26-2012
    Location
    Cordenons
    MS-Off Ver
    Excel 2016 32bit - Win 11
    Posts
    917

    Re: How do I change Module Names

    When you click on the Module you will find the fields you need in the bottom left pannel (Property).

  3. #3
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: How do I change Module Names

    While you are at module, Press F4

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: How do I change Module Names

    Don't rename your modules the same as any of your subs.
    Last edited by Norie; 11-30-2012 at 12:45 PM.
    If posting code please use code tags, see here.

  5. #5
    Registered User
    Join Date
    05-29-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    84

    Re: How do I change Module Names

    Quote Originally Posted by Norie View Post
    Don't rename your modules the same as any of your subs.
    Why does that matter?

  6. #6
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: How do I change Module Names

    Yes it does matter as it can cause problems with the code.

    Why not use a name the sub name, or if you really want to use the sub name use mod<subname>.

    For example you have a sub called Test in a module, so rename the module modTest.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1