+ Reply to Thread
Results 1 to 6 of 6

Compile Error : Method or data member not found

  1. #1
    Registered User
    Join Date
    01-31-2019
    Location
    Australia
    MS-Off Ver
    2018
    Posts
    35

    Compile Error : Method or data member not found

    Hi guys,

    I've been getting this error when using the below code for autofill using a combobox. I have about 300 sheets which are accessed by a hyperlink off two separate sheets. Only the links of one of the sheets produces this error? Any help would be great! Thanks

    Please Login or Register  to view this content.
    Attached Images Attached Images

  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: Compile Error : Method or data member not found

    The error is pretty straightforward and means there is no ActiveX control named TempCombo on the sheet with the module containing this code. I can't provide any further help without seeing the file or at least this worksheet.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    01-31-2019
    Location
    Australia
    MS-Off Ver
    2018
    Posts
    35

    Re: Compile Error : Method or data member not found

    Thanks man!

  4. #4
    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: Compile Error : Method or data member not found

    No worries, mate!

    Not that I don't appreciate it, but it took you 2 years?

  5. #5
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Compile Error : Method or data member not found


    It's like a French proverb : « Mieux vaut tard que jamais ! »

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: Compile Error : Method or data member not found

    Better late than never … after a little prompting.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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 method or data member not found will not run as a sub
    By COURTTROOPER in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-05-2018, 12:31 PM
  2. Compile error Method or data member not found
    By kwesmc1 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-30-2016, 02:47 PM
  3. [SOLVED] Compile error: Method or data member not Found
    By jasond1992 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-25-2015, 02:29 AM
  4. Compile error:Method or data member not found
    By vshukla in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2015, 11:44 AM
  5. Compile error method or data member not found
    By sureshpunna in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-14-2014, 09:00 AM
  6. [SOLVED] Compile error: Method or data member not found.
    By ndtsteve in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-10-2012, 11:31 AM
  7. Compile Error:Method or Data Member Not Found
    By loknath in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-29-2012, 04:03 AM

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