List on different worksheet
 

I wish to create a drop down list and put the list on a different worksheet
than where the drop down will be used. I also want to validate. I was able
to put the actual list on a separate worksheet using a named range but it
when a value not contained in the list was typed in the cell it did not apply
the validation (normally a stop message would come up if you indicate to do
so).

How do I ensure there is validation when a list is located on a separate
worksheet?

Attila

It works, are you using the list under allow as

=MyList

where MyList is the name of the list?

works fine for me


Regards,

Peo Sjoblom

"bevpike" wrote:

I wish to create a drop down list and put the list on a different worksheet
than where the drop down will be used. I also want to validate. I was able
to put the actual list on a separate worksheet using a named range but it
when a value not contained in the list was typed in the cell it did not apply
the validation (normally a stop message would come up if you indicate to do
so).

How do I ensure there is validation when a list is located on a separate
worksheet?

Attila

Attila

Perhaps you have unchecked the option "show error alert after invalid data is
entered".

Found under the DV "error" tab.

Has nothing to do with using a named range from another sheet.


Gord Dibben Excel MVP

On Tue, 25 Jan 2005 13:11:04 -0800, "bevpike"
wrote:

I wish to create a drop down list and put the list on a different worksheet
than where the drop down will be used. I also want to validate. I was able
to put the actual list on a separate worksheet using a named range but it
when a value not contained in the list was typed in the cell it did not apply
the validation (normally a stop message would come up if you indicate to do
so).

How do I ensure there is validation when a list is located on a separate
worksheet?

Attila

If you included any blank cells in the named range, you will be able to
type any value in the cell with data validation. If you're leaving
blanks so the list can grow, you can use a dynamic name for the range
instead. There are instructions he

http://www.contextures.com/xlNames01.html

bevpike wrote:
I wish to create a drop down list and put the list on a different worksheet
than where the drop down will be used. I also want to validate. I was able
to put the actual list on a separate worksheet using a named range but it
when a value not contained in the list was typed in the cell it did not apply
the validation (normally a stop message would come up if you indicate to do
so).

How do I ensure there is validation when a list is located on a separate
worksheet?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html