جرب
Private Sub CommandButton1_Click()
Dim lr As Integer
Dim i As Integer
lr = Cells(Rows.Count, "C").End(xlUp).Row
For i = 4 To lr
If Cells(i, 3) = Me.ComboBox2 Then
Cells(i, 2) = Me.TextBox2
Cells(i, 3) = Me.ComboBox1
Cells(i, 4) = Me.TextBox1
End If
Next
End Sub