OptionButtons in Frames

Louis · Apr 18th, 2002, 09:34 AM

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 · Apr 18th, 2002, 09:58 AM

What do you mean by FRAMES on a sheet?

Louis · Apr 19th, 2002, 02:12 AM

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 · Apr 19th, 2002, 02:25 AM

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 · Apr 19th, 2002, 02:48 AM

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 · Apr 19th, 2002, 03:36 AM

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

Louis · Apr 20th, 2002, 11:48 AM

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.

Apr 19th, 2002, 02:48 AM	#5
Ivan F Moala MrExcel MVP Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 4,209	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. __________________ Kind Regards, Ivan F Moala From the City of Sails

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 18th, 2002, 09:34 AM	#1
Louis New Member Join Date: Apr 2002 Posts: 11	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?

Apr 18th, 2002, 09:58 AM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	What do you mean by FRAMES on a sheet?

Apr 19th, 2002, 02:12 AM	#3
Louis New Member Join Date: Apr 2002 Posts: 11	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?

Apr 19th, 2002, 02:25 AM	#4
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	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

Apr 19th, 2002, 03:36 AM	#6
Louis New Member Join Date: Apr 2002 Posts: 11	Thanks very much! It works great. Ooh, how did I suffer on this...

Apr 20th, 2002, 11:48 AM	#7
Louis New Member Join Date: Apr 2002 Posts: 11	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.