+ Reply to Thread
Results 1 to 6 of 6

Compile error method or data member not found

  1. #1
    Registered User
    Join Date
    11-26-2012
    Location
    hyderabad
    MS-Off Ver
    Excel 2010
    Posts
    43

    Compile error method or data member not found

    Hi,

    I'm using the below code dependent combo box but when i opens file getting error msg "compile error method or data member not found".

    Please help. Thank you in advance.


    Please Login or Register  to view this content.
    Last edited by sureshpunna; 08-14-2014 at 12:22 AM. Reason: spelling mistake

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Compile error method or data member not found

    Please include the rest of your code.
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  3. #3
    Registered User
    Join Date
    11-26-2012
    Location
    hyderabad
    MS-Off Ver
    Excel 2010
    Posts
    43

    Re: Compile error method or data member not found

    I didnt get your answer.

  4. #4
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Compile error method or data member not found

    What is ALL_INDIA? I don't see any variables declared? Is it a named range?

  5. #5
    Registered User
    Join Date
    11-26-2012
    Location
    hyderabad
    MS-Off Ver
    Excel 2010
    Posts
    43

    Re: Compile error method or data member not found

    Here is attached is sample file. when save and re-open the error msg appering.

    Example.xlsb

  6. #6
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Compile error method or data member not found

    Maybe:

    Change:

    Please Login or Register  to view this content.
    To: ?

    Please Login or Register  to view this content.

+ 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 Method or data member not found
    By ixelister in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-23-2014, 03:39 PM
  2. [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
  3. Compile Error: Method of data member not found (VBA)
    By vbatech in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 03-14-2012, 05:37 PM
  4. 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
  5. Compile Error Method or data member not found
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-04-2005, 06: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