Hi all,

I would like to create a combo box in my VBA where the user can either expand the list and select it, OR allow the user to input the relevant letters and it will search for the closest one.

For example, in the combo box i have

1) Line
2) Lime
3) Lice
4) Like
5) Limousine

When the user first type in L or Li, all 4 will appear, and if the user type in the 3rd character, say Lim, then Lime and Limousin will be on the list.

Or when the user type in i or e, all 5 will still be displayed because they all have this character.

Can anyone help me out or any advise? I hope I am clear enough...

Thanks!
OB