Reversing List in a Combo Box

I have been asked to change a the list order in a combo box on a form, but the the list index must remain the same.

E.g if my list in the combo box shows:

001
002
003

and user selects "003" the list index is 2.

this needs to be reveresed to show:

003
002
001

but again if the user select "003" the list index should still be 2 and not 0.

An example spreadsheet is attached.

Does anybody know how to change the viewable list but preserve the original list index. (Note: I do not want to resort the original list on the worksheet)

Regards
BP

I think I thought that there was probably a way to use the IDList as an array when initialising the user form.

Then apply some method to the array to reverse the order, and use the array as the list to display in the combo box.

When the the selection is made, some formula is used against the array to calculate the original listindex of the ID List.

But I dont know how to do this.

BP