I know this is a very old topic but after googling a lot I still couldn’t find a working solution. I have a active x combobox in my worksheet “home” ,where the item source range is “itemlist” C2:C100. When I write “Ab” to the combobox search-text area I want that automaticaly the items starting with “Ab” are filtered and shown in the dropdown list (without extra expanding the dropdown). I have found following solution that works partial.

I know this is a very old topic but after googling a lot I still couldn’t find a working solution. I have a active x combobox in my worksheet “home” ,where the item source range is “itemlist” C2:C100. When I write “Ab” to the combobox search-text area I want that automaticaly the items starting with “Ab” are filtered and shown in the dropdown list (without extra expanding the dropdown). I have found following solution that works partial.