View Single Post
 
Old 08-28-2018, 03:18 AM
eduzs eduzs is offline Windows 10 Office 2010 32bit
Expert
 
Join Date: May 2017
Posts: 266
eduzs is on a distinguished road
Default 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.
Reply With Quote