Hide Unhide rows and active x controls based on option buttom

[emilemil22]

Hi everyone!

I have grouped OptionButton1 and OptionButton2//// and TextBox1 and TextBox2 in sheet 1.

1. I want to actively hide rows 10:15 along with TextBox1 and TextBox2 in Sheet 1 whenever OptionButton1 is selected.
2. Additionally I want to actively unhide rows 10:15 along with TextBox1 and TextBox2 in Sheet 1 whenever OptionButton2 is selected.

Could someone advise on Macro?

PS my workbook has multiple sheets

Many thanks, for your help.

 

[emilemil22]

Thank you very much! Just found another way of doing that without grouping. When you manually reposition the textboxes they become editable and you can write in them. Instead of doing it manually I just wrote a code for excel to do it for me (credits to user @Yongle who advised on it!)