How to use autocomplete in a combobox using Change function

[mrrada]

I have a code for a combo box (cmbVillage) that will be executed when the value of the combo box changes. But the problem is that this code enable the combo box to use the Autocomplete feature because as soon as we enter a letter the combo box start the execution of the code.

Any idea to have the Autocomplete and also the code running?

Private Sub cmbVillage_Change()
Dim Card As String
Dim r As Long

Application.Cursor = xlWait
.....


Thank you,

[gmr4evr1]

Try changing the buttons default property in VBA editor to True. I that doesn't work, try this...

Please Login or Register  to view this content.

Edit* This will allow the code to run after the Enter key is pressed