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
Bookmarks