View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] oldyork90@yahoo.com is offline
external usenet poster
 
Posts: 59
Default get Data Validation to stop, list supplied, duplicate data entries

I can write code to recognize duplicate data, but I can't figure out how
to stuff that code it into data validation where a list source is already defined.

Is there a way for the data validation facility to stop, not remove, duplicate entries which are obtained from a list?

Thanks for you help.

Excel 2010