on the userform insert a FRAME. then move all your option buttons
into the frame. it will automatically group them all together & only
allow one to be chosen.
hth
susan

On Feb 20, 1:45 pm, caroline
wrote:
When I have two option buttons on a form, I define a range as a ControlSource
in the property of the first one, and the TRUE/FALSE of that range allows me
to define which button is chosen.
Can you tell me what I need to do when I have 4 option buttons and the user
is to choose only one at the time (mutually exclusive). How can I track which
one has been chosen on the form.
Any help is greatly appreciated
Thanks
--
caroline