Set the GroupName property of the pairs of buttons the same value and add
code like

Worksheets("Sheet1").Range("A1").Value = optQ1Yes.Value * -1

to both button click events.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Pieter van der Walt" wrote in message
...
I have been asked to do a form in Excel and one portion of the form
requires
a simple Yes or No answer. The best way of doing this I thought was giving
the person who will be completing the form an option button to select
either
Yes or No. (There are approx 6 questions requiring only Yes or No answers)

I am not an expert in Excel at all and need some advise here...

How do I put in the option button in for each question to be only yes or
no
and how can I assign a value of 1 to the Yes answers that will pull
through
to a summary sheet refelcting the answers given?

Thanks
Pieter