ComboBox in serie of rows, AND google search style autocomplete

[stefimira]

Hi
I have a spreadsheet that is used as little database, where the columns G, I, J, and M take values with data validation mode from the page "PARAMETERS". When the user tabs in those columns, a combobox appears. Users must now type the first letter and then scroll down till the right word. I want the user to be able to type two or three letters and have in the drop down cobobox list only the words that contain such letters.
Es. if I type "box" in column I, I would like to see the selection "box damaged or dirty".

I used this code https://www.extendoffice.com/documents/excel/2401-excel-drop-down-list-autocomplete.html

File attached https://www.dropbox.com/s/y45ufeli6gjsb5l/FC Damages Daily Template_forum.xlsm?dl=0

thank you

 

[Fluff]

Add this line as shown

        xCombox.Activate
       [COLOR=#0000ff] Me.TempCombo.MatchEntry = fmMatchEntryComplete[/COLOR]
        Me.TempCombo.DropDown