Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: VBA module names

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    235
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there a way to rename the VBA in Excel modules to something other than module1, module2 etc. I have tried exporting them to a different name and reimporting them, but the imported version still comes back with the same module name before I exported it.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    OF cause use the VBE and rename in the viewer.. can only be one word thou so Jack_in_the_UK is fine

    Jack in the UK will fault...


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  3. #3
    MrExcel MVP Tom Urtis's Avatar
    Join Date
    Feb 2002
    Location
    San Francisco, California USA
    Posts
    11,162
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Adding to what Jack said, while in the Project Explorer of the Visual Basic Editor, select your module name (Module1 or whatever), then click on View > Properties Window (or hit F4) and you will see that module (Module1 for example) in the first field. Double click or otherwise hilite that Module1 name and type in your desired name, and close out the Properties Window, or the VBE altogether.

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    235
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks guys!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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