Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Input box to update combo box | Excel Programming | |||
Combo box update to field | Excel Discussion (Misc queries) | |||
Excel 2003 - Update or Don't Update Links Problem | Excel Programming | |||
Combo update filtering | Excel Programming | |||
Combo Box Before Update | Excel Programming |