Originally Posted by
AMoreno
@Akuini,
But I was wondering if you were able to get it to work on a "double click" rather than "Enter" key, so you could type out what you need and select it from there? Or both would be best?
Actually you can type out what you need and select it from there by using Enter Key (provided the value exists in the list). But when I try your sample workbook there's a trailing space in one entry i.e "OH ", so when I type "OH" then hit enter then it raised an error.
So you need to trim all the extra spaces in your data, and you can use this macro to do that (put it in a code module, and the sheet Balances must be the activesheet:
Anyway, if you still want to also use double-click then just add this sub:
And there's another thing, you can choose how the list is shown in the combobox, i.e:
1. You can have the list sorted.
In Sub ComboBox1_DropButtonClick() and Sub ComboBox1_Change(), uncomment this line:
2. You can use the search pattern as "word*word" (not "*word*word"), it means that if you type e.g "A" as the first letter then it only shows entries with the first letter "A".
In Sub ComboBox1_Change() you can choose it by uncommenting one line and commenting the other line.
Here's an example (sorted list & use word*word*):
Bookmarks