Michael,

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

HTH,
Bernie
MS Excel MVP


"Michael Link" <MichaelLink@discussions.microsoft.com> wrote in message
news:C75CEF75-C797-4971-BB02-8F35CF541DEE@microsoft.com...
> 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" <MichaelLink@discussions.microsoft.com> wrote in message
>> news:1FD97EF4-386F-4053-B1D3-FACA9D0FD77C@microsoft.com...
>> > 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!
>>
>>
>>