VBA Userform: Sending data to specific Sheet depending on which Option Button selected

[Clova13]

Hi all

I'm pretty new to all this so hope someone can help me.

I have a userform set up which initially asks for ComboBox1 (Cmb1) and TextBox1 (Txt1) to be filled in. Then I have two option buttons.

OptonButton1 (Opt1) brings up TextBoxes 2, 3 and 4 (Txt2, Txt3, Txt4)
OptionButton2 (Opt2) brings up Textboxes 5, 6 and 7 (Txt5, Txt6, Txt7)

I need to all the boxes brought up with Opt1 sent to Sheet 1 (Sh1) along with Cmb1 and Txt1
All the boxes brought up with Opt 2 need to go to Sheet 2 (Sh2) along with Cmb1 and Txt1
If Opt1 is selected, boxes brought up under Opt2 don't need to be filled in and vice versa.

Cmb1 is always in column A on the sheet
Txt1 is always in column B on the sheet

Everything I try isn't working. I've only been using VBA for a few days so I'm really green! Help please

Kind Regards,
Rachel

 

[James006]

@ Mike ...

Congrats ...!!!

I do admire the efficiency of your Crystal Ball ...