Free Search in Data List

[beatdrfranck]

Currently I am preparing a new file, where I would like to add some information for an item (like item number etc.) out of a master sheet. T

herefore in the "Data Validation" I added the list of item names.

When I enter a value in the cell where the data validation is active it searches for the word (e.g. "hammer") and find several entries, but only the ones where the word start with "hammer" or where the "hammer" comes after a space.

But it doesn´t find the word Schlosserhammer, where the word "hammer" is part of the word. So I have to type in "schlosserhammer".

Is there any way to make the data validation search in the full word instead of just at the beginning or after a space?

Thanks in advance and best regards, Frank

 

[JEC]

VBA approach: Let's say this is your dropdown data and your ActiveX ComboBox

Then you can use this code behind the combobox.
Make sure you set the property MatchEntry to MatchEntryNone

Private Sub ComboBox1_Change()
 With ComboBox1
    .List = Filter([transpose(a1:a8)], .Text)
    .DropDown
 End With
End Sub