Referencing Excel 2000 ActiveX controls 1

[scottrod]

I have a worksheet I'm testing controls with. I can place controls in the worksheet and run code off them but now I want to try something else. I've placed a Microsoft Forms 2.0 Frame on a worksheet. I then added two option buttons to the frame. How do I refer to those option buttons within code? The option buttons that are added are ActiveSheet.OptionButtons so I haven't figured out how to get 'down' to the button. They are embeded in the frame while the frame is embeded in the worksheet. As far as syntax, I have Sheet1.Frame1 but don't know what should go next.

 

[scottrod]

Figured it out:

Sub test()
ActiveSheet.OLEObjects("Frame1&quot.Object.OptScott.Value = 1
End Sub