See
http://www.xldynamic.com/source/xld.Dropdowns.html
Dynamic Dependent Dropdowns
--
HTH
RP
(remove nothere from the email address if mailing direct)
"JPB" wrote in message
...
A cascading list box is a list box with choices that change based on the
value a user selects in another list box. For example, clicking
Condiments
in the Categories box causes the Products box to display a list of
condiments. This example comes from an Access 2003 solution. Can it be
done
using Excel 2000?