Searchable dependent drop-down list

Not sure what your question is. When a value is in a cell from a dropdown, it behaves just as if someone typed it in, so, yes, you can search for it.

Okay. The video shows how to use a combo-box for your data selection. Interesting trick, as it allows you to auto-complete. I am lost on what you are considering to be 'search'. The video shows how it can auto-complete, which is a type of search, so I think you want something more...

Since English is not your first language (you seem to be doing well, though), I'm not sure what you understood from the video. So, my questions may seem obvious, but I want to make sure we are synchronized.
1) Did you download her spreadsheet from her website? It should have the VBA to make it work.
2) Assuming you did download her spreadsheet, is her spreadsheet working on your computer?
3) Did you try to copy her code into your spreadsheet? I don't think so, since you attached a .xls file which does not have macros.

Originally Posted by Pauleyb

Since English is not your first language (you seem to be doing well, though), I'm not sure what you understood from the video. So, my questions may seem obvious, but I want to make sure we are synchronized.
1) Did you download her spreadsheet from her website? It should have the VBA to make it work.
2) Assuming you did download her spreadsheet, is her spreadsheet working on your computer?
3) Did you try to copy her code into your spreadsheet? I don't think so, since you attached a .xls file which does not have macros.

1. Yes
2. Yes
3. Yes, the attached file is a stripped version of my real excel file (wich is a .xlsm file)
Got a lot of company stuff in the "real" excel it that had to be removed (macros etch)
I only left the sheets / data related to this topic in the example file, forgot to make it a .xlsm

My personal guess what might be causing trouble is that I want to use suggestion in a dependant dropdown box.

A standard drop-down box does not allow the auto-complete feature. You will need to modify her code to your needs. Is your problem that you are having difficulty modifying her code to your spreadsheet?

I played around a bit with her code and your spreadsheet. I assume you are following the directions on her website on how to set the MatchEntry property to 1-frmMatchEntryComplete in order to have the auto-complete enabled. A couple of things:

1) Auto-complete is not a search for the word at any place in the list. It only goes by first letter, then second letter, etc. e.g. If you have a list item called "My Test", you cannot start typing "Test" and it will find "My Test". You can only start at the beginning, so that if you start typing "M" it will go to the first list item that begins with "M", then if you type a "y" next (so that you have "My") then it will go to the first list item that begins with "My".
2) Her code only works if your data validation list is in columns. You chose a named range that is a row.

Well, you could probably change the code to take in the row of data and transpose it to the proper format. Or, and this would be easier, just transpose the row to an unused part of your spreadsheet and use that reference. Or, (and I haven't tried this, but it may work), put =TRANSPOSE(your range name) in the Name manager definition.

First, good job getting the code to work. I can't see what you did to have it support datalists that are in rows. I'm working from memory on the connexion code, but I don't see anything that converts the row to a column...

Second, I'm not sure if you can show multiple matches. A part of me believes you could key off of keypress events and determine if they are in a combo box, and, if so, then create the matching list through code, and then repopulate the combobox with the new matching list. But, I'm not sure if keydown events in a combobox are captured, and it would be tricky to continuously capture the typed in text and re-create the combobox with the new list. Doesn't seem impossible, but I have never tried it.