Friday, November 7, 2014

Auto Fill drop down list with Search Suggestions

A rather simple way of having this feature enable is:
1- Add a combo filter list box from developer options.
2- Click "view source code"
3- Add the following VBA code:

Private Sub ComboBox1_GotFocus()
ComboBox1.ListFillRange = "=DropDownList"
Me.ComboBox1.DropDown
End Sub

4- Done !

No comments:

Post a Comment