Editting Data in a table using a userform

Hi All

I have a small problem with a table which when a name needs changing the userform only only edits the first entry and stops whithout changing all the same names in the column

The code I am using is below

Private Sub CommandButton1_Click()
 n = Application.Match(Me.ComboBox1.Value, Range("b:b"), 0)
   Cells(n, 2).Value = Me.TextBox1.Value
   Cells(n, 3).Value = Me.TextBox2.Value
   Cells(n, 4).Value = Me.TextBox3.Value
   
   Sheet6.Activate
   n = Application.Match(Me.ComboBox1.Value, Range("C:C"), 0)
   Cells(n, 3).Value = Me.TextBox1.Value
   
   Sheet2.Activate
   n = Application.Match(Me.ComboBox1.Value, Range("b:b"), 0)
   Cells(n, 2).Value = Me.TextBox1.Value
   
   Sheet10.Activate
   
   

   
End Sub

The problem lies in the sheet 6 part of the code

is there a way of changing all of the same names from column C

Regards Moose