use the control source property to link them to separate cells

or (you rarely do both)

Use the click event (or other event) of each control to take the appropriate
action.

or in other code, check the controls to see whether they are selected or
not.

--
Regards,
Tom Ogilvy

"dread" wrote in message
...
When using activeX control's option buttons in a grouping (from the
control
toolbox - not the forms toolbox), how and where do you store the results
of
which option button they chose?

Thanks,

Diane