Hi Jeff

See Debra's site
http://www.contextures.com/xlDataVal01.html

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Jeff" wrote in message ...
How do I create a drop down menu in a given cell so that
it shows a pre-defined list of choices from another
location in the same worksheet?

Thanks.

Jeff