Kristin

When it fails to issue the error message, make sure that Data - Validation is set for that
cell -- perhaps it didn't get set for all of the cells which should have this validation
set.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com


-----------------------------------------------------------------------
"Kristen" wrote in message
...
Hello. I have set up Data Validation to Allow from the List that I set up.
This is working however if a user types in anything in to that cell, no error
message appears. I have selected Show error alert after invalid data is
entered on the Error Alert tab in the Validation menu. I have also entered a
title and message on the Error Alert Tab. I'm thinking it must be something
pretty simple that I can not locate on Help or in the message boards
--
Thanks - K