Hi Peo,

I refer to my list by: =Category

"Peo Sjoblom" wrote:

How is your list referred to

=$A$1:$A$10

=MyList

or something else, if you type in the list values directly you don't need
the equal sign
but you need to use comma as delimiter



--
Regards,

Peo Sjoblom

Portland, Oregon




"Phyllis" wrote in message
...
Yes, this is checked off.

Phyllis

"Kevin B" wrote:

I the "Show Error alert after invalid data is entered" checked off? If
it
isn't, no error message will appear.
--
Kevin Backmann


"Phyllis" wrote:

I have a simple list of categories that I have put into a drop down
list. I
have checked off the Error Alert box under validation and entered a
warning
message. I want to force the user to either choose a category from the
drop
down list or type it exactly as it appears in the drop down. From all
I've
read it seems that all I have to do is check that Error Alert box, but
it's
not working. I have tested it and when I enter something that is not
part of
the list it just lets me continue. No warning message or anything.

What am I doing wrong?

Phyllis