How to Set an Option Button

[onlyng]

It must be trivial Watson but...

I tried this code to refer to an existing Option Button (placed in a
User Form):

Sub HelpMe
Dim oOpt as Control

Set oOpt = Me.Frame1.Controlls("OptionButton1")
...

End Sub

It compiles wiyhout error, but when run it returns error 1004

???

 

[Jim Cone]

Controls has only one L
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


<[email protected]>
wrote in message
It must be trivial Watson but...
I tried this code to refer to an existing Option Button (placed in a
User Form):

Sub HelpMe
Dim oOpt as Control
Set oOpt = Me.Frame1.Controlls("OptionButton1") ...
End Sub
It compiles wiyhout error, but when run it returns error 1004

???

 

[onlyng]

Controls has only one L
--
Jim Cone
San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

<[email protected]>
wrote in message
It must be trivial Watson but...
I tried this code to refer to an existing Option Button (placed in a
User Form):

Sub HelpMe
   Dim oOpt as Control
   Set oOpt = Me.Frame1.Controlls("OptionButton1")   ...
End Sub
It compiles wiyhout error, but when run it returns error 1004

???

OK
You win on techinatillllity
However, I still get error 1004 with one "L".
Any serious contribution?
Thanks

 

[Rick Rothstein \(MVP - VB\)]

Try it without the reference to Frame1... the Controls collection belongs to
the UserForm, not the Frame.

Set oOpt = Me.Controls("OptionButton1")

Rick