Bob,

Take a look at Data Validation in the Data Menu of Excel.

hth,

Doug Glancy

"Bob Builder" <Bob wrote in message
...
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?