Is it at all possible to create a double drop down from field ....

I am trying to create a drop down that will narrow the choices to the second
drop down....

Example : If you choose chocolat then the second drop down will not have any
pepper and salt to it


Thanks for your help

Yes, but it will take some programming. You might be better off jumping into
UserForms.

You would create an on-exit macro for the first drop-down that would change
the choices in the second drop-down.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.


"Dyno" wrote in message
...
Is it at all possible to create a double drop down from field ....

I am trying to create a drop down that will narrow the choices to the
second
drop down....

Example : If you choose chocolat then the second drop down will not have
any
pepper and salt to it


Thanks for your help