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
Bookmarks