User form in Excel

  • Thread starter Thread starter L Guest
  • Start date Start date
L

L Guest

How is the best way to set up a form in Excel using option
buttons? I have one set up with 2 or 3 different sets of
option buttons. I have tried to set each set of option
buttons in a "group" using the "group box". The problem I
have now is that it will let me select more than 1 option
in each group. Before I grouped them, if I selected an
option in the 2nd group, it would deselect the option in
the 1st group. Any suggestions would be appreciated.
 
Since you used the term "groupbox", I'm betting your Form is a worksheet nicely
formatted.

If you used the optionbuttons from the Forms toolbar, make sure that they're
completely inside the groupbox.

If you used the optionbuttons from the Control toolbox toolbar, then you could
delete the groupbox (unless you want it there for esthetics). But right click
on each optionbutton within a "group" and select properties.

There's a GroupName property. Each group will have to have its own unique
name. (the default groupname is the worksheet name--so they're all grouped
together.)

You'll have to be in design mode (another icon on that control toolbox toolbar)
to see the properties.

===
Or you could just use the optionbuttons from the Forms toolbar and be careful
where the groupboxes are placed.
 
Back
Top