Excel 2003.
I have a worksheet with a topic heading with a drop down menu with three
choices in the adjacent cell.

Under that topic heading I have 5 statements with checkboxes in adjacent
cells.

What I'd like to do is have the topic heading dropdwn auto select one of the
three choices when a set number of checkboxes are checked.

Is this possible? How would one do so?