Hello, I need your help with form controls in VBA.
I want to write a code that would reset to false the option buttons dependent on previous one. I need something like this: If the option button 1 is selected then turn off and make invisible option button 25-58.
Problem is I have a lot of option buttons in the sheet and the numerical order in name is not allways continuous as I needed to delete some option buttons when making the form.
Is there a way to detect them so I will not have to write millions of codes for every option button separately?
Thank you for your advise
I want to write a code that would reset to false the option buttons dependent on previous one. I need something like this: If the option button 1 is selected then turn off and make invisible option button 25-58.
Problem is I have a lot of option buttons in the sheet and the numerical order in name is not allways continuous as I needed to delete some option buttons when making the form.
Is there a way to detect them so I will not have to write millions of codes for every option button separately?
Thank you for your advise