I want to setup a data validation list to allow users to only select from a
drop down box. Is it possible that once the name is selected from the list,
it is automatically deleted from the list and therefore not available after a
one time selction?

Do you actually want to delete it from the list or just hide it from being
used again? Are you willing to write a macro?


"RARomeo" wrote in message
...
I want to setup a data validation list to allow users to only select from a
drop down box. Is it possible that once the name is selected from the
list,
it is automatically deleted from the list and therefore not available
after a
one time selction?

There's a formula solution here, that hides previously used items:

http://www.contextures.com/xlDataVal03.html


RARomeo wrote:
I want to setup a data validation list to allow users to only select from a
drop down box. Is it possible that once the name is selected from the list,
it is automatically deleted from the list and therefore not available after a
one time selction?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html