ARKADAŞLAR AŞAĞIDA İKİ AYRI (Private Sub worksheet _Change (ByVal Target As Range) makrosunu aynı sayfaya girdiğimde hata veriyo çok uğramama ramen bir türlü çözemedim.yardımlarınızı bekliyorum.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim s, Dosya_Yolu As String
Dosya_Yolu = ThisWorkbook.Path & "\"
Dim yer As Worksheet
Dim bul As Range
Dim sat As Integer
If Target.Count > 1 Then Exit Sub
If Target = "" Then Exit Sub
If Intersect(Target, Range("C3,D3,E3,F3,G3,H3")) Is Nothing Then Exit Sub
Set yer = Sheets("SUÇ KAYDI")
Set bul = yer.Cells.Find(Target, , xlValues, xlWhole)
If bul Is Nothing Then
ExecuteExcel4Macro ("SOUND.PLAY(, """ & Dosya_Yolu & "KAYIT BULUNAMADI.wav"")")
Exit Sub
Else
sat = bul.Row
End If
yer.Range("A" & sat & ":L" & sat).Copy
Range("D5").PasteSpecial xlPasteValues, , , True
yer.Range("O" & sat & ":S" & sat).Copy
Range("D17").PasteSpecial xlPasteValues, , , True
yer.Range("V" & sat & ":Y" & sat).Copy
Range("D22").PasteSpecial xlPasteValues, , , True
yer.Range("AM" & sat & ":AP" & sat).Copy
Range("D25").PasteSpecial xlPasteValues, , , True
Range("F17").Value = yer.Range("AP" & sat & ":AP" & sat).Value
yer.Range("AR" & sat & ":AR" & sat).Copy
Range("D31").PasteSpecial xlPasteValues, , , True
yer.Range("BW" & sat & ":BW" & sat).Copy
Range("D32").PasteSpecial xlPasteValues, , , True
yer.Range("AS" & sat & ":Bj" & sat).Copy
Range("D38").PasteSpecial xlPasteValues, , , True
yer.Range("BY" & sat & ":BY" & sat).Copy
Range("D34").PasteSpecial xlPasteValues, , , True
Application.CutCopyMode = False
Range("D5").Activate
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, [D10]) Is Nothing Then Exit Sub
If [d5].Value > 0 Then Exit Sub
x = InputBox("LÜTFEN DAVA TAKİP NOYU GİRİNİZ ?", "DAVA TAKİP NO")
[d5].Value = x
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
Dim s, Dosya_Yolu As String
Dosya_Yolu = ThisWorkbook.Path & "\"
Dim yer As Worksheet
Dim bul As Range
Dim sat As Integer
If Target.Count > 1 Then Exit Sub
If Target = "" Then Exit Sub
If Intersect(Target, Range("C3,D3,E3,F3,G3,H3")) Is Nothing Then Exit Sub
Set yer = Sheets("SUÇ KAYDI")
Set bul = yer.Cells.Find(Target, , xlValues, xlWhole)
If bul Is Nothing Then
ExecuteExcel4Macro ("SOUND.PLAY(, """ & Dosya_Yolu & "KAYIT BULUNAMADI.wav"")")
Exit Sub
Else
sat = bul.Row
End If
yer.Range("A" & sat & ":L" & sat).Copy
Range("D5").PasteSpecial xlPasteValues, , , True
yer.Range("O" & sat & ":S" & sat).Copy
Range("D17").PasteSpecial xlPasteValues, , , True
yer.Range("V" & sat & ":Y" & sat).Copy
Range("D22").PasteSpecial xlPasteValues, , , True
yer.Range("AM" & sat & ":AP" & sat).Copy
Range("D25").PasteSpecial xlPasteValues, , , True
Range("F17").Value = yer.Range("AP" & sat & ":AP" & sat).Value
yer.Range("AR" & sat & ":AR" & sat).Copy
Range("D31").PasteSpecial xlPasteValues, , , True
yer.Range("BW" & sat & ":BW" & sat).Copy
Range("D32").PasteSpecial xlPasteValues, , , True
yer.Range("AS" & sat & ":Bj" & sat).Copy
Range("D38").PasteSpecial xlPasteValues, , , True
yer.Range("BY" & sat & ":BY" & sat).Copy
Range("D34").PasteSpecial xlPasteValues, , , True
Application.CutCopyMode = False
Range("D5").Activate
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, [D10]) Is Nothing Then Exit Sub
If [d5].Value > 0 Then Exit Sub
x = InputBox("LÜTFEN DAVA TAKİP NOYU GİRİNİZ ?", "DAVA TAKİP NO")
[d5].Value = x
End Sub