get Data Validation to stop, list supplied, duplicate data entries

O

oldyork90

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
 
A

Abhijeet Gudur

Try triggering your code with cell change(Worksheet_Change(ByVal Target As Range)). Since you already have code modify it to check- if value entered is duplicate then, delete the value entered and show warning in message box.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA for data validation in 3rd column does not run. I need help. 1
Data Validation - copy/paste 3
Using Data Validation via an array to stop manual entries - possib 4
Excel 2010/2007 - How much can be done with Custom Validation? 7
Data Validation Link to Color Coating 1
Data Validation List (conditional) 2
Alternative to Data Validation (List) 3
Worksheet protection prevents Data Validation code from running... 1

Top