On a UserForm in an Excel workbook, I have a Frame control that contains 50 option buttons (radio buttons). When the user selects any one option button, which is exclusive of all others in that frame, what is the most efficient way programmatically, in VBA, to know which option button has been selected? Once I know this I will transfer the choice onto an Excel table in a worksheet.
I have seen examples where a whole series of If...Then statements is used to test each option button to see if it is "on" but I'm hoping there is a much shorter way of getting what I need. If the option buttons are all in the same GroupName, shouldn't the Frame that holds all these option buttons have a property that gets updated with the ID or Caption of the selected option button, and that can then be read into VBA?