Hi Alex
but if the master cell is blank you can enter whatever
you like in the dependant cell.

You had not mentioned this before, and I hadn't thought to mention
Ignore Blanks.

I see you have found it though. Glad you are sorted.

--
Regards

Roger Govier


"Alex" wrote in message
...
Hi Roger,

Where abouts do you mean for show error tab? In Validation? Because it
is
ticked in there, it wont let you enter free form text if there is
something
in the master cell, but if the master cell is blank you can enter
whatever
you like in the dependant cell.

"Roger Govier" wrote:

Hi Alex

If you tick the Show error alert on the Error alert tab when setting
up
the DV, it does behave in exactly the same manner for dependant
lists.


--
Regards

Roger Govier


"Alex" wrote in message
...
This seems to be something not covered on the Webpage on dependant
lists
http://www.contextures.com/xlDataVal02.html

I notice with the dependant lists it allows you to enter free form
text,
unlike the master list which wont allow this. Is there a way of
making
the
dependant lists like any normal list in that you can't enter free
form
text?