Custom Data Entry form to post to separate worksheets dependent on a variable

I have a custom data entry form which is working fine. The form completes customer data for reviewing at a later date. I have now been asked to change it so it will seperate the data in to customer's who require some documents sent out and some that dont.

Is it possible to have a combobox on the form and if the options on the combobox are Yes and No (original), when either option is selected the data will complete on to a seperate sheet for cases with documents required or documents not required?

Is this possible or will it have to have two data entry forms?

Many thanks in advance.

I really appreciate all your help

One data entry form will suffice as long as the only requirement is to direct which sheets gets the data. I would use a checkbox control to direct which sheet receives the data.

You will need to upload your workbook with the form if you need help with the code.

Basic code example:

Private Sub CommandButton1_Click()

    Select Case Me.CheckBox1.Value
        Case True
            'code to write to sheet1
        Case False
            'code to write to sheet2
    End Select

End Sub

Here is a better example, briefly tested, but not fully developed for all of your controls on the form. This should get you going. Note that I am referencing sheet codenames and not worksheet names (matter of preference).

    Dim lrow As Long, ws As Worksheet
    
    Select Case Me.CheckBox1.Value
        Case True 'Extended Terms
            lrow = Sheet4.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
            Set ws = Sheet4
            
        Case False 'Same Terms
            lrow = Sheet2.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
            Set ws = Sheet2
    End Select
    
    With Me
        ws.Cells(lrow, 1) = .Account.Value
        ws.Cells(lrow, 2) = .Surname.Value
    End With