On Wed, Oct 16, 2013 at 8:29 PM, Secret Shot wrote:
> Dear Exterts,
>
> I am stuck in my project and need your expert advice that ho can i prevent
> duplicate data entry in any colom, but i have to use list validation too at
> the same time
>
> So for example my source range is G1:G10 on the basi
Pls use this if you like this. (sorry missed attachment in last mail)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Wednesday, October 16, 2013 8:38 PM
To: excel-macros
Subject: Re: $$Excel-Macros$$ Data validation - Need help to
Pfa, if u like to use this...
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Wednesday, October 16, 2013 8:38 PM
To: excel-macros
Subject: Re: $$Excel-Macros$$ Data validation - Need help to prevent
Duplicate Entry
try this
try this
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
If Application.WorksheetFunction.CountIf(Range("a:a"),
Target.Value) > 1 Then
Target.Value = ""
MsgBox "Duplicate entry is not allowed", vbInformation, "Note:"
End If
