+ Reply to Thread
Results 1 to 4 of 4

Combobox change event triggering unexpectedly

  1. #1
    Registered User
    Join Date
    07-08-2021
    Location
    Santa Fe, NM
    MS-Off Ver
    2019 Windows & Mac
    Posts
    8

    Combobox change event triggering unexpectedly

    I have a couple ActiveX comboboxes in the top row of a worksheet. Their ListFillRange are both set to a named range in the same worksheet. The linked cells are also on the same sheet - in row 1, but they are different for the two boxes. When I filter or unfilter the sheet using Autofilters on row 2 and things recalculate, the combobox change events are triggered. The linked cells are not in the filtered range. But some rows of the ListFillRange are. The filtering does not change the display of choices in the combobox, but for some reason the change events are triggered. Why is this happening and how can I stop this?
    Thanks

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,966

    Re: Combobox change event triggering unexpectedly

    I'd suggest you don't use the ListFillRange but rather assign the named range's values to the List property in code.
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Registered User
    Join Date
    07-08-2021
    Location
    Santa Fe, NM
    MS-Off Ver
    2019 Windows & Mac
    Posts
    8

    Re: Combobox change event triggering unexpectedly

    Thank you romperstomper. I can initialize the list as follows:
    Please Login or Register  to view this content.
    but the question is where to do that. If I do it in the change events themselves, then it gets reloaded every time the combobox is changed. One place I saw recommends loading the lists once in the WorksheetActivate event. But if I do that, the combo change events are triggered. Is there a way to disable the change events while I load the list? or?? I feel like I'm missing something...

  4. #4
    Forum Expert
    Join Date
    10-11-2021
    Location
    Netherlands
    MS-Off Ver
    365
    Posts
    1,505

    Re: Combobox change event triggering unexpectedly

    Try (behind the worksheetmodule where the combobox is located)

    Please Login or Register  to view this content.

+ 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. Vba Change event triggering code
    By UltimateNeo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-19-2019, 08:48 PM
  2. [SOLVED] MsgBox triggering unexpectedly
    By tikku.kumbo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-29-2018, 08:39 AM
  3. [SOLVED] change event not triggering macro
    By cmccabe in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-27-2014, 01:15 PM
  4. [SOLVED] Prevent change event triggering when clearing contents
    By tone640 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-03-2012, 09:34 AM
  5. RTD value changes not triggering worksheet change event
    By DTM in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2006, 12:10 PM
  6. [SOLVED] Validation not triggering Change event in Excel XP
    By Jeffrey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-12-2006, 11:40 PM
  7. [SOLVED] Validation not triggering Change event in Excel XP
    By Jeffrey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-07-2006, 10: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