+ Reply to Thread
Results 1 to 2 of 2

Difference between VBA module name and Project Properties?

  1. #1
    Registered User
    Join Date
    11-24-2015
    Location
    New Zealand
    MS-Off Ver
    2021 Professional plus
    Posts
    10

    Question Difference between VBA module name and Project Properties?

    What is the difference (and purpose) between VBA module name and Project Properties name?

    Doing a bit of research on reference libraries and came across about personalising projects to add to reference libraries.

    I renamed the project by right clicking on "Module1" and renaming Project. I then tried to rename "Module1" as same as renamed Project and wouldn't allow me to.

    This is where I need advanced training.

    Thank you

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Difference between VBA module name and Project Properties?

    The project is the name of the entire VBA project for a macro-enabled file. The default project name is VBAProject. It can be renamed using component renaming rules (e.g., some characters not allowed, may not start with a digit).

    A project can have many modules. Default module names are:

    Sheet module: Sheetn
    (Sheet modules are always created for all sheets; you cannot create or delete a sheet module)
    UserForm module: UserFormn
    Standard Module: Modulen
    Class Module: Classn
    Workbook Module: There is only one per file and it is named ThisWorkbook

    When you try to rename the module the error message explicitly tells you:
    Name conflicts with an existing module, project, or object library
    A module and its project cannot have the same name.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Fix properties & Project Window in Module
    By RAJESH SHAH in forum Excel General
    Replies: 5
    Last Post: 01-22-2023, 04:16 PM
  2. [SOLVED] Name conflicts with existing module, project or project library.
    By L.LEE in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-22-2017, 04:10 AM
  3. Project Properties Checkbox
    By JSMITHXX in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-11-2013, 08:51 PM
  4. Replies: 1
    Last Post: 08-30-2011, 02:23 AM
  5. Project Properties (Forms and Macros)
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-17-2009, 02:20 PM
  6. VBA Project Properties
    By dipitiduda2 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-18-2006, 04:00 PM
  7. Problems Setting properties of class module
    By Andibevan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-02-2005, 09:05 AM

Tags for this Thread

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