Userform transferring data to sheet in a specific row

[usmanishfaq2009]

i want ot transfer data from a user form to a sheet but in specific row select from combobox value. with this code i didn't get any error nor data to sheet
here is the code i am using but no progress.

Private Sub CommandButton1_Click()
Worksheets("EOM").Activate
Exit Sub
Worksheets(TargetRow).Activate
If ActiveSheet.Cells(TargetRow, 1) = ComboBox1.Value Then
'copy data to ActiveCells
ActiveSheet.Cells(TargetRow, 2).Value = TextBox1.Value
ActiveSheet.Cells(TargetRow, 3).Value = TextBox2.Value
ActiveSheet.Cells(TargetRow, 4).Value = TextBox3.Value
ActiveSheet.Cells(TargetRow, 5).Value = TextBox4.Value
ActiveSheet.Cells(TargetRow, 6).Value = TextBox5.Value
ActiveSheet.Cells(TargetRow, 7).Value = TextBox6.Value
ActiveSheet.Cells(TargetRow, 8).Value = TextBox7.Value
ActiveSheet.Cells(TargetRow, 9).Value = TextBox8.Value
ActiveSheet.Cells(TargetRow, 10).Value = TextBox9.Value
End If

thanks for your help