Joined Combo Boxes
 

In my spreadsheet I have part numbers and descriptions. I have a Forms Combo
box that lists the part numbers in order. I have another combo box tied to
the same cell, referencing the desriptions range so whenever I select a part
number in one combo box it will display the description in the other box, and
likewise when I select the description it will display the part number in the
other box. Is there a way to have the descriptions display in alphabetical
order and the part numbers to be in order also? It seems I can have one or
the other only. I do not want to use macros or the control toolbox, strictly
the Forms combo box.

Thanks as always,

Squeaky