drop down lists embedded in cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
....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
 
Thanks to everyone that responded was a great help, very much appreciated.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pick from drop-down list gives empty or erroneous result 6
How to dynamically change the list in drop down list based on thevalue of another cell? 1
Data Validation List (conditional) 2
EXCEL DROP DOWN 2
problems when removing validation 1
Drop Down List 2
Colour-coding a cell from a drop down list 1
Excel Excel: How do I put a formula in a drop down list 11

Back
Top