+ Reply to Thread
Results 1 to 2 of 2

Listbox.listcount property - application defined or object defined error

  1. #1
    Registered User
    Join Date
    12-17-2012
    Location
    Lebanon, NH, USA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Listbox.listcount property - application defined or object defined error

    Hi,

    I am struggling with a really weird and annoying error. I have this line of code in a macro:

    Please Login or Register  to view this content.
    This line is throwing the run time error 57121 - Application defined or object defined error.

    Here is the weird/annoying part - Only certain computers are giving this error. This code works absolutely fine on my laptop but is giving the run time error on a colleague's computer.

    "UtilSelectServiceListBox" is an activex listbox control. I have to know the number of items in this listbox for the program to work further so I am open to any/all suggestions that will fix this issue. It is extremely annoying that this is an issue on only certain machines. I also searched for alternatives to the "ListCount" property and couldn't find any that solved my issue.

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Listbox.listcount property - application defined or object defined error

    Hi,

    Since this is occurring on selected computers, the problem is probably due to a Microsoft update from December 14th, 2014 that affects 'Active X'.

    The following URL has a 'fixit' link that may solve the problem. https://support.microsoft.com/kb/3025036

    Lewis

+ 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. Previously working code is now is now giving Application-defined or object-defined error
    By ready2learn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-06-2014, 07:22 PM
  2. [SOLVED] application-defined/object-defined error 1004 when trying to read from or write to cells
    By florin_excel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-30-2012, 08:38 AM
  3. Replies: 2
    Last Post: 09-12-2012, 01:01 PM
  4. Application Defined or Object Defined Error, Command Button and Vlookup Function
    By stevedomer in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-14-2011, 11:20 PM
  5. Replies: 3
    Last Post: 07-24-2006, 08:20 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