How to return OptionButton from a UserForm

[rsbuzatto]

Hello folks,

I'm developing a UserForm which has 19 OptionButtons. Then, I need to code some conditionals, however, it might be better if I just return the selected OptionButton from the UserForm. This is my issue!

Does anyone knows if it's possible to return the selected OB from user?

I really don't wanna code 5 tons of conditionals for that... :\\


Thanks a million guys... I really need this help!

 

[yogiraj]

Hi,

Make function like below

function function_name(obj as object) as Object ' function take button as parameter

'''''''''''''''''''''' your code here'''''''''''''''''''''''''''''
function_name=obj 'this means function will return object of that button

end function

Yogesh Dalimbkar

 

[rsbuzatto]

Sorry, but I guess it wouldn't work for me...

I have 2 separated groups... one with 7 OptionButtons and the othe group with 12 OptionButtons, in the same UserForm... got it?! :\\


Any other help... please!?

 

[rsbuzatto]

Just to notice:

I need to return the OptionButton from Product Frame and the OptionButton from Period Frame... Then, I need to return the Year from ListBox! :X

If I couldn't return this from user's selection, I'm destroyed (lol :\\)

Thanks....

 

[rsbuzatto]

Hey folks,

I got what I was looking for...

Follow the code for you who want a similar routine.

Dim button As Control        For Each button In Me.Controls
            If TypeName(button) = "OptionButton" Then
                If button = True Then
                    MsgBox button.Name
                End If
            End If
        Next

Thanks everyone...