Overlapping Dropdown lists combobox

[jensslofstra]

Hi everyone,
Lately I've been working on my vba skills with a combobox. (especially dynamic dropdown lists)
I think I have a pretty good understanding of what a combobox is capable of but can't figure this out.

In the attachment you will find my excel workbook.

Now the problem:
I've created a dynamic dropdown list and it works great except for one thing, the display of the dropdown list.
Fruit DropDown 1.png
This is the entire list. But when you type the list will only display the items that have does characters.
Fruit DropDown 2.png
But after the second given character the dropdown list compresses and is only one ListRow heigh.
Also the previous dropdown list which isn't filtered will show as an after image of sorts.
Fruit DropDown 3.png

This is the code I am using:

Please Login or Register  to view this content.

Can anybody help me solve this problem?

[Akuini]

Try this code:

Please Login or Register  to view this content.

Are you planning to use multiple combobox in multiple cells (in range B3:B25)?
If yes then you may find this type of searchable combobox useful:

[jensslofstra]

Thanks a lot Akuini.
I got rid of the Private Sub Combobox1_GotFocus() but the filter works great.

[Akuini]

You're welcome, glad to help, & thanks for the feedback.