Check out this link...

http://www.xldynamic.com/source/xld.Dropdowns.html
--
HTH...

Jim Thomlinson


"Karen Smith" wrote:

I've created a drop down menu for cell I4 that allows users to choose A, B, C
or D. Depending on what letter they choose, I want another drop down menu.
Such as, if they choose A, I want their choices to be Apples, Oranges,
Grapes. If they choose B, I want their choices to be Grapefruit, Kiwi,
Plums. And so on. How do I do that?