G'Day Mark,

Option buttons are ALREADY mutually exclusive. If you have
two or more option buttons on a userForm then setting any one
will reset all the others.

If you Group option buttons in Frames, then each Group will
operate independently.

By default, the value is set to 0, so that NO option buttons are (pre)
selected. If you set the value of any one option button (per group) to 1
then that button will be set when the Form is displayed.
--
Regards,
Pat Garard
Melbourne, Australia
_______________________

"Mark" wrote in message
...
How do I make a form with Mutually Exclusive Option Radio Buttons? I am
trying to create a form that will constrain the person filling in the data
to
chose from only available choices. Such as only choosing Yes, No, or
N/A,
or from 1 through 10 on a survey of agreement to disagreement. This
would
help in keeping the data cleansed for going into a database. How do I do
that? Please help me figure this one out. It seems too simple to not be
doable.

Thanks,
Mark