Combobox find part matches from defined range (POWER FUZZY SEARCH)

Hello,

I have searched about this for a while and cant find anything that appears to help me.

I have a combobox object on my "sheet1" it is populated from a defined range ( lets say a1:a100 )

In my defined range I have 100 items all with unique names.

Currently as I type in the combobox it finds matches in my range that start with what the user has typed.

Is it possible to have the combobox to find any/part match ? So if I type : bus it will return : red bus / blue bus / green bus as possible matches ?


Attached is a rough design ( this is apart of a bigger stock system I have written and refining) - Fuzzyfindcombobox.xls

Hi hutzdani and welcome to the forum,

A sample workbook with the code and combo box would help solve this problem. You can attach a sample file by clicking on "Go Advanced" below the message area and then on the Paper Clip Icon that appears above the Advanced Message area.

In general you should have some VBA code that filters the data based on the first letters of the combo box every time you press a letter. You will need to find this line of code in the VBA and change it so those letters are found anywhere in the A1:A100 range.

See the link to how they do this in Access VBA http://blogs.office.com/b/microsoft-...cess-2010.aspx

Solved this one :

Please Login or Register  to view this content.

Change ITMLST and its range dependant on what range of values you want to fuzzy search.

sample workbook here - Fuzzyfindcombobox.xls