Combobox doesn't retain selected value when sorting ListFillRange

**LukasK** · 07-17-2013, 11:58 AM

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

**LukasK** · 07-18-2013, 10:38 AM

bump

Thanks!

**Norie** · 07-18-2013, 10:41 AM

Lukas

You need to store selection(s) somewhere and then reselect them after you've sorted.

**LukasK** · 07-18-2013, 11:40 AM

Thanks Norie!

I made a simple example, all in one worksheet. As you can see, two cells next to the combobox are using the vlookup function to show the values from the table, based on the combobox selection. I've also added this code to a worksheet, so when you add new items to the table, they are automaticaly visible in the combobox:

Please Login or Register  to view this content.

However, when you sort some of the table columns, the selection is changed.

Could you please try to add your suggestion to this simple example, or at least give me some more information about it, so I can try it myself?

Thanks a lot!

Lukas