+ Reply to Thread
Results 1 to 4 of 4

Stop seemingly default action of copied activex component

  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

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Stop seemingly default action of copied activex component

    Hello TravelByFirework,

    The problem lies with your code NamesCbx_Click(). Both drop downs are referencing the same cell on the "Template" worksheet. To get the ComboBox to look at the Range on the same sheet as it is on, use the Me keyword to identify the worksheet.

    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

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

    Re: Stop seemingly default action of copied activex component

    Thank you so much Leith. I was looking for something along the lines of a "this" keyword and had even seen Me in the debugger but never connected. I wish I had posted here weeks ago

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Stop seemingly default action of copied activex component

    Hello TravelByFirework,

    It is always the small things that create the biggest problems. Glald I could help.

+ 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. 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