How to Select Radio Button w/ VBA for Macro inside Macro on Form Control w/ Potential Loop

Hi Community,

I am working on a project where I currently have an existing Form Control that pops up in the Excel Worksheet. Different radio buttons can be selected. After selected, I can choose to click "Run Report" where the macro will based on the radio button selections, generate the appropriate report from data stored in Excel.

My challenge:
What I would like to do is to create a separate Macro, that will initialize this macro, and then click on the desired radio buttons (both in groups or independently), and then to run the macro to produce the report.

After, I would like the macro to re-open the Form Control, and select different radio buttons to produce other reports.

The goal will be to potentially create this as a loop, or more simply one at a time, with in-between saving these reports to a separate excel file.

At the end of the macro, I would have a new excel file with all the reports in one workbook.

Where I am currently having a challenge is how to have the macro auto-select the radio buttons I would like to use and to run the report.

Happy to provide further insights, as I explore the code methodology to complete.

Thank you!

Kind Regards,
David

Thanks for your reply Tinbendr.

For clarity this is a UserForm that pops up in Excel through the Ribbon.

I would like to take all these worksheets, and then save them in a new workbook as Paste Special Values only, to reduce the file size and improve the file loading time.

This sounds like a good idea, to add another command button that iterates all the option buttons to create reports. However, I am not familiar how to do this. Would you have any recommendations?

Thank you Tinbendr.