Hey,
I'm using a Combobox (ActiveX) to select the values from a database, which is in another excel file. Since the database is gonna be frequently updated, is it possible to make the Combobox remember selected value, even when I sort the ListFillRange in the database file?
For example, I have the first value selected in my Combobox, which starts on a letter "a", but when I sort the column of the database table from Z-A instead of A-Z, the selected value changes to something, which starts on a letter "z".
Thanks for any advice!
Lukas
Bookmarks