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