your point!
All the best,
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ChilExcel
Sent: Wednesday, October 05, 2011 5:32 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row
Thank
ula 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
Jai
another excellent solution provided by Rajan Berma
Try this :
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo Err:
Dim lngValueAs Long
Dim intICounter As Integer
Dim strMsg As String
Dim lngValue2 As Long
lngValue = Target.Value
lng
excellent solution, launching the message showing the repeat value
thank you very much for your time and attention Rajan
Chilexcel
2011/10/5 rajan verma
> Try this :
>
> Private Sub Worksheet_Change(ByVal Target As Range)
> On Error GoTo Err:
> Dim lngValueAs Long
> Dim i
Try this :
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo Err:
Dim lngValueAs Long
Dim intICounter As Integer
Dim strMsg As String
Dim lngValue2 As Long
lngValue = Target.Value
lngValue2 = Target.Offset(0, -1).Value
If Intersect(Target
Or (slaps head) --
Just use:
=countifs($B$2:$B$1000,$B2,$C$2:$C$1000,$C2)=1
Asa
From: Asa Rossoff [mailto:a...@lovetour.info]
Sent: Tuesday, October 04, 2011 9:40 PM
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate en
e 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
Please see Mathai solution proposed by Sam Chacko
Excellent!
Private Sub Worksheet_Change(ByVal Target As Range)
Dim lngCount As Long
Dim lngLoop As Long
Dim strMsg As String
lngCount =
Evaluate("=SUMPRODUCT((Hoja1!$B$2:$B$57&Hoja1!$C$2:$C$57<>)*(Hoja1!$B$2:$B$57=Hoja1!B"
& Ta
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
> Try this Code :
> this Code enable you to check the duplicate entry at the time of Data Entry
> ..
>
>
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 lngValueAs Long
Dim intICounter As Integer
Dim strMsg As String
lngValue = Target.Value
If Intersect(Target, Range("
I need also this VB Code
On Mon, Oct 3, 2011 at 4:41 AM, ChilExcel wrote:
> Urgent !!
> i Need VB lines codes for
>
> 2011/10/1 ChilExcel
>
>> hi
>>
>> i Need VB lines codes for
>> Alert MsgBox Pair duplicate entry in row
>>
>> Column D function account and duplicates alerts (NO Problem!
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sam Mathai Chacko
Sent: Monday, October 03, 2011 12:16 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row
Chil,
Paste this code in the sheet
Excellent, exactly what I needed thank you very much Sam !!!
2011/10/3 Sam Mathai Chacko
> Chil,
>
> Paste this code in the sheet code module of the respective sheet. Now once
> any entry is made in any row of B & C, it will check and display a message
> if any duplicate is found.
>
> Priva
Chil,
Paste this code in the sheet code module of the respective sheet. Now once
any entry is made in any row of B & C, it will check and display a message
if any duplicate is found.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim lngCount As Long
Dim lngLoop As Long
Dim strM
Urgent !!
i Need VB lines codes for
2011/10/1 ChilExcel
> 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
> Vi
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
--
--
16 matches
Mail list logo
