OptionButton - Unable to set names properly within Frame

[Anonymous]

I am getting an error when I try to set multiple OptionButton names to the same name (within a frame) on a UserForm. The message I get is "Could not set the name property. Ambiguous Name."
I want to be able to use this as a Control Array, so the OptionButton names within the frame should have the same name......is this not correct.
I would appreciate any help here....thanks
John V.

[Ed__Jobe]

vba does not support control arrays. I have worked around that in the past by using incremental alphanumeric names, i.e Control001, Control002, etc. I then examined the number portion of the name. I used this technique to create a number of textboxes at runtime according to the number of text items in the selection set.

[Anonymous]

Thanks for the info.
Taking your example, I've been able to do the work around using an IF statement within the click-event of the OptionButton. Each button would need the IF.
You still need to keep the OptionButtons within a frame to treat them as a group. It works so far, so I'll keep it.
ie:

If optBtn1.Value = "True" Then
....code.....
End If

thx.
JV

[Anonymous]

John,

I emulate a control array in VBA forms by using the frame's
Tag:

Private Sub optFull_Click()
  fraSF.Tag = 1#
End
Sub

Private Sub optHalf_Click()
  fraSF.Tag = 2#
End
Sub

Private Sub optEighth_Click()
  fraSF.Tag = 96#
End
Sub

HTH

--
R.
Robert Bell, MCSE
www.AcadX.com

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

"JohnVanderwelle" <
href="mailto:john.vanderwelle@homehardware.ca">john.vanderwelle@homehardware.ca>
wrote in message
href="news:f132078.1@WebX.maYIadrTaRb">news:f132078.1@WebX.maYIadrTaRb...

Thanks
for the info.
Taking your example, I've been able to do the work around
using an IF statement within the click-event of the OptionButton. Each button
would need the IF.
You still need to keep the OptionButtons within a frame
to treat them as a group. It works so far, so I'll keep it.
ie:

If optBtn1.Value = "True" Then

        ....code.....

    End If

thx.
JV