Help VBA command

[Halos]

Dear All,

I have created new USERFORM1 and added comboBox which there multiple selection types. Please see below code:

Private Sub ComboBox1_Change()
With ComboBox1
        
    End With
End Sub

Private Sub CommandButton1_Click()
If ComboBox1 = vbNullString Or TextBox1 = vbNullString Or TextBox2 = vbNullString Or TextBox4 = vbNullString Then
MsgBox "Butun xanalar doldurulmalidir"
Else
      
      Sheets("hesab" + ComboBox1.Value).Rows(6).Insert
      
      Sheets("hesab" + ComboBox1.Value).Range("C6") = TextBox1
      Sheets("hesab" + ComboBox1.Value).Range("D6").Value = TextBox2.Value

When I select one of the selection type from the box, this copy to the sheet name "hesab".

The problem is I cannot create new comboBox2 and put command to affect same sheet which name is "hesab" but copy info another column. For example, I select one of the type "book" and this automatically copied to the sheet which named "hesab". But I want to create new comboBox (which already created) and want to lync to the same sheet named "hesab" and copy to the other range.

Thanks

Khalid