Embedded Option Button Grouping

  • Thread starter Thread starter Eiserman
  • Start date Start date
E

Eiserman

Hello,

I am trying to embed 3 groups of option buttons in an Ecxel
spreadsheet. I was wondering how to differentiate the radio buttons
from each group (i.e. have 3 separate lists) without having to resort
to VBA and proper forms.

At the moment the grouping of the buttons seems random


Thank you in advance.
 
It depends on where those optionbuttons came from:

If the optionbuttons are from the Forms toolbar, put each group within a
GroupBox (also on the Forms toolbar).

If the optionbuttons are from the ControlToolbox toolbar, then right click on
each, select properties. Give each member of each group the same GroupName
property. (They all default to the sheet name--so they're all grouped together
to start.)


====
And if you used the Forms optionbuttons and want the GroupBox to be invisible,
you can do this:

Hit alt-f11 to get to the VBE
hit ctrl-G to see the immediate window

type this in and hit enter:

activesheet.groupboxes.visible = false

This hides all the groupboxes on the activesheet.
 
Back
Top