Forum Discussion
Auto complete text in a drop down list cell
Hi everyone, Trying to do a spreadsheet and figured out how to make the drop down list box (yay). But I would like to have the option of auto completion of words when I type a few letters in...
Excel doesn't allows the drop down to Autocomplete, generally we use for Data Validation.
Therefore you have to work with Combo box, is one of the Active X controls.
Please check this link,,, I've shown how to do it all about Autocomplete.
i have succesed created a list combo box (Active X Control) and vba code :
Private Sub ComboBox1_Change()
ComboBox1.ListFillRange = "DropDownList"
Me.ComboBox1.DropDown
End Sub
and the combo box like this :
but if i want to select the list data below by arrow (on the keyboard), excel in error like this :
how to solved this problem..?