Grouping Option Buttons

T

TechWriterMichael

I am creating a form that has repetitive groups of option buttons. In other
words, I have several identical groupings of options buttons.

How can I ensure that one button within each group can be selected, instead
of only one option button out of the entire form?

Thanx!
 
J

Jay Freedman

TechWriterMichael said:
I am creating a form that has repetitive groups of option buttons.
In other words, I have several identical groupings of options buttons.

How can I ensure that one button within each group can be selected,
instead of only one option button out of the entire form?

Thanx!
Click to expand...

Just to be sure -- you're talking about option buttons from the Control
Toolbox, and not ones in a VBA userform, right?

In each button's Properties dialog, put an entry in the GroupName property.
All the buttons that are part of the same group should have the same
GroupName value. That should be different for each group.
 
T

TechWriterMichael

Yes, I was talking about the Control Toolbox. That did it for me!!!

Thanx for you help, Jay!
 
Top