Automated search in drop down list

[SMM]

Hi

In a cell I need to put a word or some letters so this would triger a search in a column containing about 3000 cells. What I need is that as i am typing the letters, a drop down list to appear with all the cells containing what I typed so I can select the one I needed.

Please note that the letters or word I will put will not necessarily be the first letter or word in the search column.

ie: if I type "house"
the items containing house would be : "Villakil house" , "mount house virmint" etc....
I need these items to be shown in the list so I can select.

I am not sure I need a macro for this or not but I will appreciate your help

[Whizbang]

This can be done fairly easily in a userform, but the worksheet only has a "change" event that occurs once the user confirms their entry.

It might be possible to write a Class Module to create a new event that senses each change while still in edit mode, but I wouldn't know how to write it.

What you could do is use the BeforeDoubleClick event to sense if a certain range is being edited, then open a Userform, which would allow for adjusting the dropdown for every character change entered, and then feed the final value into the worksheet range.

[SMM]

Hi Whizbang,

Can you please elaborate more on how I should write the code for the useform? Will this give a drop down list of all the items containing the typed in letters?
Even though I have to confirm my entry I would like to try it to see if it is enough

Thanks for your help

[snb]

A combobox in a worksheet. cfr. the attachment.