Hi
see:
http://www.contextures.com/xlDataVal01.html

--
Regards
Frank Kabel
Frankfurt, Germany

"Bob Builder" <Bob schrieb im
Newsbeitrag ...
Hi,

In a presentation recently I saw a user access a drop down list by
selecting
a cell, that previously had no drop down arrow in it. The cell also
did not
contain any formula but took the value selected from the drop down
list, when
the user selected a different cell the drop down arrow disappeared.
I've
tried recreating this effect using standard control boxes such as a
list box
or combo box but to no avail. Any ideas what it is and how do I go
about
doing it?