userform combobox - autocomplete with drop down box

[ajm]

has anybody got a snippet of code to make a combobox auto complete? as the user types in a name into the cbo, i would like them to be able to select from a list that drops down below the combobox.

 

[Akuini]

This is an example of a searchable combobox in userform:

https://www.dropbox.com/s/op00l707u8qxdnj/dhee - searchable combobox-userform - example.xlsm?dl=0

 

[ajm]

thanks Akuini. I have inserted your snippet into my existing code where I think it should go. I get a Run time Error 70: Permission Denied error at

.List= d.keys

 

[ajm]

error because i was filling the cbo from RowSource. How do I adjust the code so that when an entry is backspaced away, the other form fields are deleted also? so by deleting the selected user from the cbo box, i want the first name, last name, phone, etc fields cleared. And need listbox cleared of selections if any?

 

[Akuini]

How do I adjust the code so that when an entry is backspaced away, the other form fields are deleted also? so by deleting the selected user from the cbo box, i want the first name, last name, phone, etc fields cleared. And need listbox cleared of selections if any?

I think it is a different problem, so you need to start a new thread. And I suggest you provide a sample workbook and upload it to a free site such as dropbox.com & then put the link in the new thread.
I will help if I can.