optionbutton

What code would I use to return which optionbutton within a given frame is
checked (true)? I've tried using a for each loop but I can't figure out the
correct collection to use. I'm new to userforms (if that's not already
obvious). Thanks for the help.

Dim ctrl as Control
Dim oBtn as MSForms.OptionButton
for each ctrl in Userform.Frame1.controls
if type of ctrl is MSForms.OptionButton then
if ctrl.Value = true then
msgbox ctrl.name
set oBtn = ctrl
exit for
End if
end if
Next


--
Regards,
Tom Ogilvy


"benb" <benb@discussions.microsoft.com> wrote in message
news:8D57F5AB-1615-4B9B-9EEE-4AFEE6C8CBD0@microsoft.com...
> What code would I use to return which optionbutton within a given frame is
> checked (true)? I've tried using a for each loop but I can't figure out
the
> correct collection to use. I'm new to userforms (if that's not already
> obvious). Thanks for the help.