Combobox to trigger sub only when item selected by click
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.
|