Results 1 to 4 of 4

Stop seemingly default action of copied activex component

Threaded View

  1. #1
    Registered User
    Join Date
    01-19-2018
    Location
    Michigan, USA
    MS-Off Ver
    2016
    Posts
    9

    Stop seemingly default action of copied activex component

    I have been scratching my head over this for quite sometime, however I think I have discovered the root cause if not a solution.

    using an activex button on sheet1 to create a copy of sheet template which has an activex combobox on it creates the copy just fine.
    The combobox which was renamed in the copy process, has code that searches the current sheet before allowing the addition of the selected item to the list on the sheet. this code works as well in fact it works twice as well. What I mean by that is that it appears that the combobox code is running first from the template then again from the new copy.

    If you select a new item, the list will be updated, then you will get an immediate "duplicate found" warning.
    If you select an existing item, you will get back to back "duplicate found" warnings.

    Does anyone know of a way to stop this behavior.

    The attached xslm file give a stripped down version to allow you to see what is happening.

    TIA
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. For the Mac Run-time error 429 ActiveX component can't create object
    By Jsalisbury in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-15-2021, 04:56 AM
  2. Runtime Error 429 - ActiveX Component Can't Create Object
    By bmaster123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-23-2015, 04:37 PM
  3. activex component can not create object
    By kirema10 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-27-2014, 09:25 PM
  4. Error 429: ActiveX component can't create object
    By manali7120 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2013, 01:31 PM
  5. Run-time error '429' ActiveX component can't create object
    By gamaz in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 12-29-2012, 10:24 PM
  6. [SOLVED] Run-time-error '429': ActiveX component can't create object
    By Lloyd Blankfein in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-28-2012, 07:21 PM
  7. Cannot Create ActiveX Component when trying to call .Net DLL from Excel VBA
    By Anthony in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-26-2006, 11:10 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