Students are creating an application type spreadsheet with comboboxes and named ranges. We want to link the top combobox with a specific list for the second combobox. i.e. choose from fruit or vegetables in the first box, and dependent on choice, correct list of either fruit or vegetables drops down in second. Know I have done this before, but seem to be brain dead this week! Can anyone help?