Thanks Asa, but I need to launch MsgBox Alert I have used function and runs well .. I have no problem
Thanks good contribution 2011/10/5 Asa Rossoff <a...@lovetour.info> > Hi Chil,**** > > I didn't realize you were looking for a pair of cells matching to determine > duplicates when I suggested the data validation rule using countif.**** > > ** ** > > You can modify that data validation rule using a sumproduct formula that > will search for that pair of data.**** > > ** ** > > This validation rule works for me:**** > > =SUMPRODUCT(($B$2:$B$1000=$B2)*($C$2:$C$1000=$C2))=1**** > > ** ** > > Apply this formula with the other info in my first post and I think you'll > be set.**** > > ** ** > > Sumproduct works because it takes as arguments one or more arrays, and can > be used as an alternative way to specify an array formula like this one.** > ** > > ** ** > > Asa**** > > ** ** > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *ChilExcel > *Sent:* Tuesday, October 04, 2011 6:33 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in > row**** > > ** ** > > Thanks Rajan I need is to columns B and C (together) > containing the mirrored pair in same row > good solution you propose, but only in column B duplicate**** > > **** > > Thanks Rajan**** > > 2011/10/4 rajan verma <rajanverma1...@gmail.com>**** > > Try this Code :**** > > this Code enable you to check the duplicate entry at the time of Data Entry > .. **** > > **** > > Private Sub Worksheet_Change(ByVal Target As Range) > **** > > Dim lngValue As Long > Dim intICounter As Integer > Dim strMsg As String > lngValue = Target.Value > If Intersect(Target, Range("B:B")) Then > For intICounter = 1 To Target.Row - 1 > If Range("B" & intICounter).Value = lngValue Then strMsg = > strMsg & "Row" & intICounter & vbCrLf > Next intICounter > End If > If strMsg <> "" Then > strMsg = "Duplicate Record of " & Target.Value & vbCrLf & vbCrLf & > strMsg > MsgBox strMsg > End If > > End Sub > > **** > > On Mon, Oct 3, 2011 at 10:15 PM, ChilExcel <chilexcel...@gmail.com> wrote: > **** > > hi > > i Need VB lines codes for > Alert MsgBox Pair duplicate entry in row > > Column D function account and duplicates alerts (NO Problem!)**** > > Attach File , thank you all > > -- **** > > Visita ; http://sites.google.com/site/chilexcel/Home**** > > Visita ; http://www.youtube.com/user/timextag41**** > > ** ** > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel**** > > > > > -- > Regards > Rajan verma > +91 9158998701**** > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel**** > > > > > -- **** > > Visita ; http://sites.google.com/site/chilexcel/Home**** > > Visita ; http://www.youtube.com/user/timextag41**** > > ** ** > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel**** > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel