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?

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?

....and within the Validation Criteria section go to the Allow dropdown and
select List. Then enter the list into the Source box. The source can be a
direct range reference e.g. "=$A$1:$A$10", a named range "=MYLIST" (say
MYLIST is the name assigned to $A$1:$A$10) or even a list itself e.g.
"1;2;3;4;5". Note1: do not use the quotation marks when entering the
formulae. Note2: Just in case your System's list separator is "," you may
need to replace ";" with ",".

KL

"Doug Glancy" wrote in message
...
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?

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?

Thanks to everyone that responded was a great help, very much appreciated.