See if this helps:

http://contextures.com/xlDataVal02.html

--
Biff
Microsoft Excel MVP


"David Robinson" wrote in message
...
I need to create a drop down list, that changes selections, based on the
value of a different cell. For instance, if the value in the key cell is
Apples, then the drop down list will have different kinds of apples for
the
selections. If the value in the key cell is Peaches, then the same drop
down
list will now show different kinds of peaches for the selections. How is
this done?