Combo Box loses visibility on selection

My knowledge of excel formula is very basic so I don't understand the formula you use to set up your searchable combobox. But in my opinion your searchable combobox is a bit inefficient & buggy.
I have created a searchable combobox that can work faster (without using formula).
You can try this sample workbook:



If you’re interested in this approach, I can help you set this up to suit your need.

Thanks Akuini - yours really is a lot slicker. I'm liking it, Meets all needs. Have had a quick look and not too sure "how" its working, but irrespective, it does so very well. many thanks

You're welcome, just let me know if need help to set it up in your workbook.

I think I may need some help - guided by your VB comment lines, ive been up all night simply trying to get your button working with my list. I failed miserably - unless I had the two together oddly (?????))
I simply want your approach/ComboBox on my "Drugs list". You'll see the slight difference in our report structures is that my "Add" button adds to the next available line in the (excel) Table (by way of a linked cell to the Combo properties - not sure if your add routine can be tweaked for this, and that the clear button, deletes all Table rows bar the first
Ill be tidying up the list itself (to make monthly updating a bit easier) and, although im now doubting even my basic skills lol, I think ill be OK populating the formulas within the summary table to. Really do appreciate this - many thanks

I must say, I am so impressed with your solution. I have started and stopped working on this problem many times over the last couple of years.

Looks like the list start reference was case sensitive - working a charm. Thanks again

I got error “permission denied” when I tried to run my code in your workbook. So I created a new workbook & copy the sheet Part VIIIA&B to it (I didn’t copy the rest of the sheets).

Note:
1.To insert data in the next empty row in col A & B, I use Sub CopyStuff_1()
2.The search pattern in the combobox is *some letter* some letter, so typing “fa cap” can find something like “Alfacalcidol 1microgram capsules - 30”
3.Why do you need col Display? Isn’t it the same with col Drug?

Here’s the workbook:

Originally Posted by _MANNY_

Looks like the list start reference was case sensitive - working a charm. Thanks again

Not sure what you mean by "the list start reference".
But the search in the combobox is case insensitive.