how to link two combo boxes

[fredz0003]

Hi I am trying to figure out how to link two combo boxes. I have two combo boxes on the first worksheet, in cell B17 I have one combo box and from the control toolbox and using listfil in properties I assigned a list on another worksheet, same in cell C17, so my question is if I select a value out of B17 combo box, I want to populate the value on C17 automatic, because B17 is a part number and C17 is part description so both should be link together, also how can I save both fields to the next row