Hey there
I'm brand new to VBA in excel and am creating my first userform. I've managed to create dependent combobox (my 'Project Name' Combobox depends on the 'Type' Combobox), but since there are a LOT of project names I would like this combobox to be a bit more flexible in terms of searching when typing. More specifically when typing a letter (or letters) I would like a list with suggestions that include all entities that include these, not just the ones that starts with those letters as it does in my combobox in my userform (I have tried to illustrate what i mean in sheet 'Searchable Drop Down'). I have found different suggestions on how to do this, but I can't get it to work with my dependent combobox. Could anyone help me on this issue?
Thanks!