OptionButtons in Frames

[Louis]

When I use frames to contain radiobuttons (on a sheet, not on a from), the buttons are not visible when I am out of the edit mode. "Send to back" does not help? Anyone?

 

[Al Chara]

What do you mean by FRAMES on a sheet?

 

[Louis]

I mean when I use the Frame control directly on a worksheet, not on a form. It seems that it always stays on top and cannot be sent to back?

 

[Audiojoe]

You could try grouping the radio buttons, then dragging them off, resizing the frame so it's just a little bit larger, then dragging the buttons back on. I dont draw controls directly onto the sheets much, but I do have this problem with frames when I create userforms

 

[Ivan F Moala]

The Frame on a worksheet is an embedded
self contained object that will hold its
own objects.
What you have to do is to
1) Get into Edit mode
2) Select the Frame
3) Right click on it and select Frame
object > EDIT
4) From the Edit mode select the ActiveX
control buttons and place them in the
container.
If the ActiveX toolbox doesn't appear then
right clci k again and from the selection
choose > Toolbox....select your control
to insert into the container here.

 

[Louis]

Thanks very much! It works great. Ooh, how did I suffer on this...

 

[Louis]

Adding controls this way to a Frame control which is placed directly on a sheet, is it still possible to attach code to the control, ie are the controls added to a frame still usable as ActiveX controls? It does not seem so.