I have 15 radio groups on a spreadsheet. They are named mgrp 1 ... mgrp 15. They all call the same macro, set_medals(oevent), which uses the oevent to determine which group was activated and different things happen based on the name of the group. Each radio group has 3 radio button controls. Everything works as desired. My problem comes with a reset button. I want the macro triggered by the reset button, reset_grps(oevent), to set all 15 radio groups to the first option in the group and to perform the same action that a manual change of each group would. I've got the first part done. I can change all of the groups to the first option. I hoped that would trigger the executed event for the various radio groups but it did not. So now I am trying to add code that either triggers the event or calls the set_medals macro with the proper oevent. I haven't been able to figure out how to do either method. I have a ctrl variable containing the control I am trying to activate. I have done
ctrl.state = 1.
I need something like
execute(ctrl) or
oevent = ctrl.execute
call set_medals(oevent) or
oevent.changed = true which hopefully would trigger a changed event. I found a statement that seemed to claim that events could be triggered by event handlers but it was not demonstrated.
Is something like this possible? using oo basic