Thanks for your help Gord. But I do not want user to be able to enter text
into the cell with the validation list, problrm is wether the check box is
clicked or not. You can type anything into the cell you want to. As for the
other problem, everyone tells me to refer to that site, but my problem is not
shown there. I am not wanting multiple list drop downs. I just want to list
column a and select the choice, but it puts the column b in the cell?


"Gord Dibben" wrote:

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?