+ Reply to Thread
Results 1 to 2 of 2

Excel bugs with activeX objects

  1. #1
    Forum Contributor
    Join Date
    01-08-2016
    Location
    Cagayan De Oro City, Philippines
    MS-Off Ver
    2013
    Posts
    152

    Excel bugs with activeX objects

    Hi, i spent the last 6 months developing an excel file that basically just access a database and performs operations with the help of active x objects here and there but im getting some problems with certain objects at certain times....... i think these are all actually related to a single combobox and hopefully 1 fix will fix it all......

    i need to describe some events that are happening to give you a little picture....

    when the workbook opens a certain sheet is made active which contains a single combobox, this combobox is filled with a list retreived from a database and then thats usually it until the user selects an item. the first problem i get is there is what looks like a combobox appear near the top of the screen (like a duplicate of the one on the sheet) with an item in it and this seems to prevent anything running in vba, its a ghost or clone or something and its causing problems........ if i click on it it will try loading something and nothing happens and it just disapears (i guess it is trying to load the selected items data from the database) then i can refresh the sheet with a refresh button i have but the code fails when setting the combo.List to the array i setup, i get an error message saying 'Permission Denied' and it wont populate. the array is populated ok, the combobox list proprty has an array of (0 to -1, 1 to 0) at this point.....

    any ideas?

    i know activex (especially comboboxes) have lots of internal problems regarding staying 'In Contact' with excel and i have gotten around most problems but this one stumped me and google is not helping , most people get this error after using the listrange property but i never use this and i only use AddItem if the array is empty..............

    (Lightbulb Idea) if this combobox has an item from the previous session that was put there using AddItem, will trying to set the list property be a problem??????

    Note i am using combo.Clear anytime i change this comboboxes data... however i noticed even after this it still has a list that is NOT empty.....it has the weird array setup (0 to -1, 1 to 0)......

    Thanks
    Paul

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Excel bugs with activeX objects

    In general, just never use ActiveX controls on worksheets. They always have issues like this.

    Can you use a normal forms based dropdown? Or move your control onto a userform?

+ 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. ActiveX objects stop working
    By fenfool in forum Excel General
    Replies: 3
    Last Post: 12-03-2015, 01:49 PM
  2. [SOLVED] Macro Is Deleting all Pictures and ActiveX Objects
    By nwb in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-24-2014, 01:26 PM
  3. Return Value from ActiveX objects in word to Excel cell with VBA
    By Bredo2102 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2014, 07:42 AM
  4. Microsoft ActiveX Data Objects 2.9 Library
    By timdecker in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-20-2014, 02:55 PM
  5. Can I protect activex-objects?
    By Crüe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-01-2011, 01:09 AM
  6. reference to MS ActiveX Data Objects 2.8 Lib
    By MCCCLXXXV in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-19-2009, 02:18 PM
  7. [SOLVED] Worksheet ActiveX Objects
    By Nigel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-01-2005, 01: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