Option Buttons separate from each other

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

ExcelMonkey

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
 
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)
 
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.
 
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)





.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top