You could turn off the Error Alert for the data validation cells. Then,
when the dropdown arrow stops working, type any entry in a cell.

If you want the dropdown arrow to continue to work, but to show an empty
list, you could create a range named AnyValue, which is a single blank
cell. Then modify the data validation formula:

=IF(COUNTA(NameCheck)=0,AnyValue,NameCheck)

newbie16 wrote:
Thanks xLBaron but i guess my question was too vague because i think you dont
know my problem.

On http://www.contextures.com/xlDataVal03.html they show you how you can
make a validation list (something like a combo-box) which removes choises
that have been choosen earlier. If you have a list that contains 6 different
names you can make a dropdown list, when youve selected (some) cell(s) doing:
Data|Validation|Allow-List and for 'source' you type something like A1:A6
But if you want multiple cells that have the same validation list, but dont
want to be able to make the same choise twice then this site shows you how
this can be done. Ive read it all and it worked.

There is only one problem. If you have excactly 6 cells with the same
validation list containing 6 names and you have chosen for each cell a name,
you cant undo this. This is because the functions in the example on that site
delete the choises you already have done. So when all choises are used, you
cant click the 'V' sign on the right of a validation-list-cell. What can i do
about that? I thought of making the list one cell larger by adding a lable "
". But that cell should be an unlimited choise unlike the rest of the list.

Check the site for more clarification.

Thanks in Advance




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html