<div>
Hi again,<br />
<br />
I have created the following function to get the value of the option button selected. <br />
<br />
Is this the proper way to get this info ?<br />
<br />

<pre><code id="code-20-37799042-1">Private Function get_comment_type(ByVal comment_frame As frame)

Dim o As Control
Dim comment_type As String

For Each o In comment_frame.Controls
    If o.Value = True Then
        comment_type = o.Caption
        Exit For
    End If
Next o

get_comment_type = comment_type

End Function</code></pre>
<br />
It works quite well - but I was wondering if it is needed, or if it is accessible directly from the frame object.<br />
<br />
Cheers,<br />
<br />
Craig
</div>


Hi again,

I have created the following function to get the value of the option button selected.

Is this the proper way to get this info ?



Private Function get_comment_type(ByVal comment_frame As frame)

Dim o As Control
Dim comment_type As String

For Each o In comment_frame.Controls
    If o.Value = True Then
        comment_type = o.Caption
        Exit For
    End If
Next o

get_comment_type = comment_type

End Function


It works quite well - but I was wondering if it is needed, or if it is accessible directly from the frame object.

Cheers,

Craig

<div>
Terrific - again !!<br />
Thanks Dave.
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
i would like to understand how to know which option button has been chosen in an option group (frame) on my form.<br />
<a href="https://filedb.experts-exchange.com/incoming/2012/04_w14/565090/3-04-2012-10-27-48-AM.jpg" target="_blank" title="Userform (341 KB)"><img alt="Userform" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2012/04_w14/800_565090/3-04-2012-10-27-48-AM.jpg" /></a>.<br />
<br />
How can I find the value, or, which radio button has been selected ? <br />
I have tried me.frame2.blah.... but I can't see a property in the frame2 collection referring to which option/radio button has been selected.<br />
<br />
Any help is appreciated.<br />
<br />
Thanks,<br />
<br />
Craig
</div>
</div>


3-04-2012-10-27-48-AM.jpg

Hello,

i would like to understand how to know which option button has been chosen in an option group (frame) on my form.
.

How can I find the value, or, which radio button has been selected ? 
I have tried me.frame2.blah.... but I can't see a property in the frame2 collection referring to which option/radio button has been selected.

Any help is appreciated.

Thanks,

Craig

Excel userform option button / frames - retrieving value

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.