Using Option Buttons from the "Forms" Menu
Option buttons placed on a sheet are linked by default. As you add more
option buttons they are linked to the intial option button. To get around
this you can place a Frame around a button (or group of buttons) to break the
link. Buttons in a frame are linked to each other and nothing else. Note
however that when you break the link the buttons are now completely severed
and while you can specify seperate cells for the return value, you loose the
mutually exclusive option of the radio buttons.
The only effective way that I know of to get around this is to use buttons
from the control toolbox. They can be linked to seperate cells while still
being part of the same group...
--
HTH...
Jim Thomlinson
"D Jones" wrote:
I am tyring to set up two different "option buttons" (radio button) lists on
the same worksheet.
Evertime I add a "option button" it shares the same linked cell as the
option buttons I have already placed on the sheet.
How do I assign different link cells to two different sets of "option
buttons" on the same wooksheet?
I really appreciate you help
Thanks,
|