I want my Combobox (userform) to trigger sub ONLY when the item selected by click, not when I type some text and this text corresponds to a value in the list.
Using click event: the problem is that when I type a text that corresponds to a item in the list and try to click in this item, this does not triggers any click event (click, mouseup, mousedown).
Using change event: when I type some text and this text corresponds to a item in the list it triggers the event, even when I was typing only to search items in the list.

Is there any solution for this?
Thank you

__________________
Backup your original file before doing any modification.

Apparently there is no solution to this.
I've found a workaround by my self, I add a double " " blank space in each list item so that the value typed in the combo box never matches a value in the drop down list that will ensure that the click event will always work.
In the Change event I alway remove the extra blank spaces to return the combobox value to the actual value.

Thanks!

For collaboration purposes only, here's some parts of my code:

__________________
Backup your original file before doing any modification.