Excel UserForm - Returning Selection with VBA

[PosseJohn]

Greetings to All,

I have a Userform that has several option buttons.

I am using GroupName to isolate the appropriate buttons into groups.

Is there a method to return the ID of the selected option button that was selected for each GroupName?

Do I need to use Frames around each group instead?

Thank you.

[torachan]

you do not need frames around group if you are using 'GroupName'.
you could use a 'function' to i.d. which button is 'true' or 'false'
a copy of your workbook would be useful so that we could give you an in-context solution.
the attached file demos the use of GroupNamed grouping - the app is 'elastic' - add another batch of ten questions to the table and the app expand dynamically without any need to add any more code.

[PosseJohn]

Thank you for the quick response, you actually did answer the question by saying I could use a 'function' to determine selection. I am doing this. I guess my question should have been more direct as 'Is there a return value from GroupName that I can use to determine which item in the group was selected.

Perhaps a thought for MS, allow user to assign tag values and the groupname would return the selection's tag value.

Nonetheless, thankyou.

[torachan]

attached a simple 'button class' module that intercepts the option button selected - it will save you many lines of individual code.
the demo userform has two banks of four option buttons - the message box will give you the details you requested.
this method is better illustrated in my calendar attached which uses the same technique to intercept the day buttons.(double click column 'A' or 'B' to activate calendar form)