Is there a way to synchronize 2 combo boxes in Excel? I.e., limit the values
in the 2nd box depending on what was selected in the first? I do this often
in Access but don't work much in Excel.

The first combo box is based on a list of major codes found on a separate
sheet. The second box is based on a list of sub-categories listed on a third
sheet, which shows each major code and the sub-categories appropriate for it.
All three sheets are in the same workbook.

How can I do this?

Thanks,
Jen