+ Reply to Thread
Results 1 to 3 of 3

Compile Error Cant find object

  1. #1
    Registered User
    Join Date
    02-04-2015
    Location
    Hartford, Connecticut
    MS-Off Ver
    2013
    Posts
    10

    Compile Error Cant find object

    Im having a problem with my Userform. I works great on 3 of my computers but for some reason on a couple other ones its having a hard time working. Basically its saying it cant find sheet4( where the data is to be entered) even though the name of the sheet is sheet4. I cant figure out why its not recognizing the sheet. Ive changed the name and tried that and it didnt work. I change my code to sheet 5 and it entered it in fine there. Any help would be great

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Compile Error Cant find object

    Can you attach the Workbook?

    Remove any confidential data..
    Cheers!
    Deep Dave

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Compile Error Cant find object

    Hi, Dutchace,

    if you have access to the computers where the code fails to work properly please check the references on these computers to see if any broken links are reported and make sure to either install the missing libraries or uncheck these in order for the code to work.

    And please do not duplicate the question here on ExcelForum in a another thread (http://www.excelforum.com/excel-prog...nd-object.html).

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

+ 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] 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
  2. Compile error: Object required
    By Hinnerk in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-23-2012, 04:38 PM
  3. Replies: 3
    Last Post: 10-25-2011, 02:12 PM
  4. Compile Error - Can't Find Object or Library
    By adam2308 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-06-2009, 07:23 AM
  5. Compile Error: Invalid use of object
    By Barb Reinhardt in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2006, 03:05 PM

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