Option Buttons separate from each other
 

I have 3 sets of two options buttons (6 total). I want
to be able to set them up so that buttons 1 and 2 work
together but are not related to 3 and 4 or 5 and 6. Is
there any way to do this? Problem I am having is that as
they are option buttons, clicking 1 means that I cannot
click 3 or 4 in group two or 5 or 6 in group three.

Thanks

Option Buttons separate from each other
 

Is it a userform? If so, put the linked option buttons within a frame.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ExcelMonkey" wrote in message
...
I have 3 sets of two options buttons (6 total). I want
to be able to set them up so that buttons 1 and 2 work
together but are not related to 3 and 4 or 5 and 6. Is
there any way to do this? Problem I am having is that as
they are option buttons, clicking 1 means that I cannot
click 3 or 4 in group two or 5 or 6 in group three.

Thanks

Option Buttons separate from each other
 

If these are optionbuttons from the Forms toolbar used on a worksheet, put each
group in its own GroupBox (another icon on that Forms toolbar).

If these are optionbuttons from the Control toobox toolbar (either on a userform
on on a worksheet), you can group them by making the GroupName unique for each
group.

You'll have to show the properties for each optionbutton.

ExcelMonkey wrote:

I have 3 sets of two options buttons (6 total). I want
to be able to set them up so that buttons 1 and 2 work
together but are not related to 3 and 4 or 5 and 6. Is
there any way to do this? Problem I am having is that as
they are option buttons, clicking 1 means that I cannot
click 3 or 4 in group two or 5 or 6 in group three.

Thanks

--

Dave Peterson

Option Buttons separate from each other
 

Thanks. The frame approach worked fine!




-----Original Message-----
Is it a userform? If so, put the linked option buttons
within a frame.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ExcelMonkey"
wrote in message
...
I have 3 sets of two options buttons (6 total). I want
to be able to set them up so that buttons 1 and 2 work
together but are not related to 3 and 4 or 5 and 6. Is
there any way to do this? Problem I am having is that
as
they are option buttons, clicking 1 means that I cannot
click 3 or 4 in group two or 5 or 6 in group three.

Thanks


.