Uncheck "Show Error Alert etc." under the Error Alert Tab and you can type in
anything you want.

Your other problem may be resolved by a dependent list.

See Debra Dalgleish's site for more info.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Sun, 30 Sep 2007 14:54:01 -0700, Kenny
wrote:

i have the list validation applied to the cell, and error alert is checked. I
can select from the list and it populates the cell with that info, or I can
just ype anything I want to in the cell, even if it is not on the list and it
allows this?