optionbutton

[Guest]

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.

 

[Tom Ogilvy]

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