Sorry... Thanksgiving Day long weekend in Canada....
I downloaded: DataValComboboxSheet.xls
This one specifically talks about creating a Combo-box that gets used
anywhere where you double click on a Validation list:
http://www.contextures.com/xlDataVal11.html
Rob