Private Sub CommandButton2_Click()
If OptionButton3.Value = True Then
Worksheets(2).Range('D1') = UserForm1.TextBox1 & ' ' & UserForm1.TextBox2 & [C1]
Else
Worksheets(3).Range('D1') = UserForm1.TextBox1 & ' ' & UserForm1.TextBox2 & [C1]
End If
End Sub