I originally tried what everyone seemed to say, put the code in the
Workbook_Open event, but it was saying that the object was not defined.

I ended up changing the event in the sheet to ComboBox1_DropButtonClick() so
that the list would generate on the click event. For the second combobox,
that fills based on the selection of the fist, I just assigned the first
title for the default.



"dan dungan" wrote:

I'm wondering what you tried that didn't work.