+ Reply to Thread
Results 1 to 7 of 7

Compile Error: Cant find project or library

  1. #1
    Registered User
    Join Date
    03-22-2017
    Location
    San Francisco
    MS-Off Ver
    Windows 7 professional
    Posts
    29

    Question Compile Error: Cant find project or library

    Everytime I want to run my userform i get the following error: Compile error, Can't find project or library.

    In a code line it highlights the word DATE and gives me the error shown in the picture.

    Private Sub UserForm_Initialize()
    TextDate.Value = Format (*DATE*, "mm/dd/yyyy")

    Note: The asterisks before and after DATE are not present in the real code. I wrote them to show you what letter was highlighted.

    error.PNG

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,173

    Re: Getting error Compile Error: Cant find project or library

    I don't see anything highlighted on your screenshot.

  3. #3
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,840

    Re: Compile Error: Cant find project or library

    May be from Tools >> References .. You would find "Missing" libraries. Un check these missing ones and save then try again and see if the problem is solved or not
    Regards
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Compile Error: Cant find project or library

    From the VBE, do Tools > References. See any at the top of the list marked MISSING?
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Registered User
    Join Date
    03-22-2017
    Location
    San Francisco
    MS-Off Ver
    Windows 7 professional
    Posts
    29

    Re: Compile Error: Cant find project or library

    yes it works. Perfect thank you!!

  6. #6
    Registered User
    Join Date
    03-24-2019
    Location
    Sacramento, CA
    MS-Off Ver
    2013
    Posts
    1

    Re: Compile Error: Cant find project or library

    I had the exact same error message. However, when I tried to click on References, it was greyed out and was not selectable. Any idea on what to do in this scenario?

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,110

    Re: Compile Error: Cant find project or library

    masterdesi06, welcome to the forum

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Please start a new thread - See Forum rule #4

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. compile error: can't find project or library
    By abhilash0728 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-15-2016, 01:22 PM
  2. [SOLVED] Compile Error in Hidden Module and Compile Error: Can't find project or library
    By Taislin in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-10-2013, 07:03 PM
  3. Compile error: can't find project or library
    By smart_as in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2011, 06:45 AM
  4. Compile Error: Can't find project or library
    By gone83 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-13-2011, 09:23 PM
  5. Compile Error - Can't find project or Library
    By bmasella in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-10-2007, 07:55 PM
  6. [SOLVED] Compile Error: Can't Find Project or Library
    By BeckenhamDave in forum Excel General
    Replies: 0
    Last Post: 01-25-2006, 08:40 AM
  7. [SOLVED] Compile error: Can't find project or library
    By Vince in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2005, 12:05 PM

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