If only run first line and skip the others

[Capa7md]

Hi i want ti edit my data by using if and when i run the code it just go to first line and skip the others

Private Sub CommandButton1_Click()
Dim LastRow As Long
Dim NewRow As Long
LastRow = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row
For NewRow = 3 To LastRow
If Sheet1.Cells(NewRow, 1) = CInt(Me.TextBox6) Then
Sheet1.Cells(NewRow, 2) = Me.TextBox1
Sheet1.Cells(NewRow, 3) = Me.TextBox2
End If
Next NewRow



End Sub

 

[Capa7md]

@Capa7md , when you step through your code, just before the IF statement executes, what are the Values of NewRow and LastRow?

@Capa7md , when you step through your code, just before the IF statement executes, what are the Values of NewRow and LastRow?

The lastrow is 7 and newrow will be the row which i want to make an update on ir and it will take the value of row if the if was true