Hi, I'm still fairly new to VBA and I'm looking for some code that can help me on a combobox droplist. I could fins code that only does parts of the requirement.
I have an Activex COmbobox (Not userform) that has a predefined listfillrange. When I start to enter in the combobox, I want the droplist to only show results form the listfillrange than contains the text entered. Note, not starting with that text, but containing that text anywher in the string of each value in the listfillrange.
Example:
Lets say my range is:
October
november
bergkamp
Octopus
When I start typing "o" the droplist should be visible only showing the 3 options that has an "o" in them regardless of their position. When I continue to type and add the "c" (I.e. "oc" in the field), it will now only show "october" & "octopus". Same if I enter "ber" it should show "october", "november" & "bergkamp" as options. When adding a "g" (I.e "Berg") it should now only show the 1 remaining match option.
I should then be able to key down and enter or select with mouse. Then press tab to take me to another combobox.
Bookmarks