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.