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?