aşağıdaki makro hep aynı satıra kaydediyor. lütfen yardım çıldıracağım
Private Sub CommandButton1_Click()
On Error Resume Next
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Dim bak As Range
Dim say As Integer
For Each bak In Range("A2:A" & WorksheetFunction.CountA(Range("A2:A65000")))
If bak.Value = cbad.Value Then
MsgBox "Bu Kayıt numarası bulundu."
Exit Sub
End If
Next bak
For Each bak In Range("a2:a" & WorksheetFunction.CountA(Range("a2:a65000")))
If StrConv(bak.Value, vbUpperCase) = StrConv(cbad.Value, vbUpperCase) Then
MsgBox "Bu isimde bir kaydınız bulundu"
Exit Sub
End If
Next bak
say = WorksheetFunction.CountA(Range("b2:b65000"))
TextBox1.Value = say
Cells(say + 1, 1).Value = TextBox1.Value
Cells(say + 1, 2).Value = cbad.Value
Cells(say + 1, 3).Value = TextBox3.Value
Cells(say + 1, 4).Value = TextBox4.Value
Cells(say + 1, 5).Value = TextBox5.Value
Cells(say + 1, 6).Value = TextBox6.Value
Cells(say + 1, 7).Value = TextBox7.Value
Cells(say + 1, 8).Value = TextBox8.Value
Cells(say + 1, 9).Value = TextBox9.Value
MsgBox "Veriniz Kaydedildi", , "KAYIT"
cbad.RowSource = "Sayfa1!b2:b" & say + 1
TextBox1.Value = WorksheetFunction.Count(Range("A2:A65000")) + 1
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub
Private Sub CommandButton1_Click()
On Error Resume Next
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Dim bak As Range
Dim say As Integer
For Each bak In Range("A2:A" & WorksheetFunction.CountA(Range("A2:A65000")))
If bak.Value = cbad.Value Then
MsgBox "Bu Kayıt numarası bulundu."
Exit Sub
End If
Next bak
For Each bak In Range("a2:a" & WorksheetFunction.CountA(Range("a2:a65000")))
If StrConv(bak.Value, vbUpperCase) = StrConv(cbad.Value, vbUpperCase) Then
MsgBox "Bu isimde bir kaydınız bulundu"
Exit Sub
End If
Next bak
say = WorksheetFunction.CountA(Range("b2:b65000"))
TextBox1.Value = say
Cells(say + 1, 1).Value = TextBox1.Value
Cells(say + 1, 2).Value = cbad.Value
Cells(say + 1, 3).Value = TextBox3.Value
Cells(say + 1, 4).Value = TextBox4.Value
Cells(say + 1, 5).Value = TextBox5.Value
Cells(say + 1, 6).Value = TextBox6.Value
Cells(say + 1, 7).Value = TextBox7.Value
Cells(say + 1, 8).Value = TextBox8.Value
Cells(say + 1, 9).Value = TextBox9.Value
MsgBox "Veriniz Kaydedildi", , "KAYIT"
cbad.RowSource = "Sayfa1!b2:b" & say + 1
TextBox1.Value = WorksheetFunction.Count(Range("A2:A65000")) + 1
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub