Combo Box Sorting Update Problem
 

Hi,

I am having a issue with a combo box giving me wrong values when i add
information to a table after sorting it. Sorry this explanation might
be slightly long winded.

eg.

Worksheet1

Id Name
1 aaa

2 bbb
3 ddd

Worksheet2

Comboboxs looking up range (Worksheet1,Name)



So i can select ddd from the combo box and that works fine. Now using
a form i add a new IdNumber and Name to Worksheet1.

1 aaa
2 bbb
3 ddd
4 ccc

I then need to sort this data so it is in alphabetical order, which i
can do fine. It now looks like so:

1 aaa
2 bbb
4 ccc
3 ddd

I then look back at my combo box in Worksheet 2 and instead of showing
ddd like it did before it shows ccc.

How can i remedy this so that it continues to show the original value
but allow the data to be alphabetically sorted?


--
kanuvas
------------------------------------------------------------------------
kanuvas's Profile: http://www.excelforum.com/member.php...o&userid=27911
View this thread: http://www.excelforum.com/showthread...hreadid=476178