Filter combo box values as you type in

[nkpan]

Hello,

I have an excel userform where i have a dropdown which has all the name of user from user table of access database.

I am looking for something where user can type in and each letter entered should filter the dorpdown values of the combobox.

Any help would be highly a[ppreciated.

Thanks
Nkpan

[JKwan]

try this:
Code was posted here - http://dailydoseofexcel.com/archives/2018/03/28/userform-textbox-autocomplete/#comments


Private Sub ComboBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
' prevent dropdown list appearing and cycling thru list
If KeyCode = vbKeyDown Then
KeyCode = 0
ElseIf KeyCode = vbKeyUp Then
KeyCode = 0
End If

End Sub

Private Sub UserForm_Initialize()

With ComboBox1
.ShowDropButtonWhen = fmShowDropButtonWhenNever
.AddItem "John Here"
.AddItem "Jonn There"
.AddItem "Donna Here"
.AddItem "Logan There"
.AddItem "Ethan Everywhere"
End With

End Sub