data validation not enforced with a named range source excel 2002 sp2

[Jeffx]

I have a cell with the following data validation settings
that still allows any cell value inspite of the
validation. The drop down list works, but is not enforced.
How can I enforce this validation?

Settings:
Allow=List
Ignore Blank=Yes
In-cell dropdown=Yes
Source="=Comment" (Comment is a named range)

Input Message:
Show message...=Yes
Title and message entered.

Error Alert:
Show alert...=Yes
Style=Stop
Title and message entered.

 

[Peo Sjoblom]

Source should be

=Comment

I don't know if that is what you have?

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Debra Dalgleish]

If there are blank cells in the source range, any value will be allowed
in the data validation cell.

If that's the problem, you could use a dynamic range as the source.
There are instructions here:

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

 

[Guest]

Yes to both questions.

Source is:
=Comment

I need a blank cell by default because of what I am using
this for, so there is a blank cell in the range specified.

I will take a look at using a dynamic range and thanks for
the assistance!