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:
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