No, it's definitely not working. The data in the cell with the validation is
restricted correctly, because it only accepts data that appears in the source
cells for the list on the other sheet, but no drop-down box appears. (I
double-checked that "In-Cell Dropdown" was checked on the validation pop-up.)

I'm running this on Excel for Mac--I wonder if that has something to do with
it.

"Bernie Deitrick" wrote:

Michael,

Make sure you select "List" and check "in-cell dropdown"

HTH,
Bernie
MS Excel MVP


"Michael Link" wrote in message
...
Is there a way to get a drop-down list to actually appear, though? I've named
the source cells, and the cell on the other sheet does accept only data from
those cells (thanks!), but I really need a drop-down box to actually appear.
Is that possible?

"Max" wrote:

Use a named range, say MyList,
then put as the DV source: =MyList

Debra Dalgleish has good coverage on the steps at her:
http://www.contextures.com/xlDataVal01.html

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Michael Link" wrote in message
...
I have a data-validation list box. Is it possible for the source cells for
the list to be on another sheet from the one in which the list-box
appears?

I know similar questions have been asked before (I poked around before I
submitted this), and one fellow suggested that a data-validation iist-box
can
reference another sheet if the list on the other sheet is named. Sadly, I
don't know how to do this. If cell A1 on Sheet 1, for example, has a list
box
whose source cells are Sheet 2, A1:A20, how do I assign a name to get the
validation to work? No matter what I do, I get a pop-up saying that
validation cannot reference other sheets. Help!