.
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
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
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 rajanverma1...@gmail.com
Try this :
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo Err:
Dim lngValue
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
@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
!
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
Thanks Asa
I need also this VB Code
On Mon, Oct 3, 2011 at 4:41 AM, ChilExcel chilexcel...@gmail.com wrote:
Urgent !!
i Need VB lines codes for
2011/10/1 ChilExcel chilexcel...@gmail.com
hi
i Need VB lines codes for
Alert MsgBox Pair duplicate entry in row
Column D function account and
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,
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
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$57Hoja1!$C$2:$C$57)*(Hoja1!$B$2:$B$57=Hoja1!B
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
Excellent, exactly what I needed thank you very much Sam !!!
2011/10/3 Sam Mathai Chacko samde...@gmail.com
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
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 code
Urgent !!
i Need VB lines codes for
2011/10/1 ChilExcel chilexcel...@gmail.com
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 ;
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
--
15 matches
Mail list logo