combobox autocomplete does not recognize click event

[mdavid]

Hi I have a combobox with autocomplete.
If I select from the dropdown select list then the OnClick event fires - and I move the selected value to a textbox, but if I use autocomplete to find the term without opening the dropdown list the OnClick event does not respond.
How do I get the OnClick event to fire on autocomplete.

Thanks for any help
David

 

[Hui]

David

You may have to use ComboBox1_Exit property

That fires once the focus leaves the Combobox

eg:

Private Sub ComboBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
'your code here
End Sub

 

[mdavid]

Thanks for this Hui, it works as you say when I move the focus away from the combobox, but I need it to work when I press enter after using autocomplete - is this possible?

Thanks for your help
David