+ Reply to Thread
Results 1 to 4 of 4

Object Suddenly Causing Problems

  1. #1
    Registered User
    Join Date
    11-16-2013
    Location
    OK
    MS-Off Ver
    Excel 2013
    Posts
    33

    Object Suddenly Causing Problems

    So I have a listbox object that has always worked just fine. Today, when I open my file, I get a compile error: method or data member not found. This is nothing fancy, just a listbox, and the listbox itself isn't even functioning correctly independent of the vba.

    I've attached an example of the file, and have been through everything I can think of. Any ideas what's causing the sudden problem?

    problem example.xlsm

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Object Suddenly Causing Problems

    Works for me.

    Probably this:

    http://excelmatters.com/2014/12/10/o...ivex-controls/

    Regards, TMS
    Last edited by TMS; 01-22-2015 at 04:46 PM. Reason: Fix link
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    11-16-2013
    Location
    OK
    MS-Off Ver
    Excel 2013
    Posts
    33

    Re: Object Suddenly Causing Problems

    Quote Originally Posted by TMS View Post
    Works for me.

    Probably this:

    http://excelmatters.com/2014/12/10/o...ivex-controls/

    Regards, TMS
    That was it!

    Thank you very much, I thought I was going crazy.

    The full link got cut off in yours, so in case anyone needs it:
    http://excelmatters.com/2014/12/10/o...ivex-controls/

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Object Suddenly Causing Problems

    You're welcome.

    Sorry about the link ... what you get for copying from another similar thread. Fixed in first response. Must go, another one to fix

+ 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. Read-Only causing saving problems
    By johncassell in forum Excel General
    Replies: 0
    Last Post: 04-07-2009, 04:37 AM
  2. Please Help! Object Required suddenly, was working before!
    By Duncan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2006, 01:35 PM
  3. Rand () causing Problems.
    By JCary in forum Excel General
    Replies: 1
    Last Post: 03-06-2006, 06:40 PM
  4. [SOLVED] Splash Screen Causing Problems
    By Kevin R in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-17-2005, 10:05 AM
  5. Is Excel causing me system problems?
    By Sandra in forum Excel General
    Replies: 1
    Last Post: 04-07-2005, 05:06 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