I think what you want is a "dependent dropdown box". Try this link to one of
Debra Dalgleish"s pages:

http://www.contextures.com/xlDataVal03.html

Just remember that the lists have to be alphabetic!!

Carole O

"dme82" wrote:

Is there any way in Excel to base one combo box on the contents of another?