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

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

i dont use option buttons much but this i what i have learned.I aint much on
macros etc so i use the forms toolbar a lot.There is a option button on the
forms toolbar
click on the option button and click on the sheet where you want it,and
repeat
right click on the button and edit the text to say yes or no.right click
on the yes button and select copy and paste 5 times,then copy no and paste 5
times.You now have to click on a group box and drag one around each pair of
buttons,edit the group box text to say question 1 to 6.if you right click on
an option button you will see a cell link location,this cell link could be on
your other sheet.when you select an option button you will see the cell link
cell 1 or two depending on which button you select.You only need one cell
link per pair of buttons.you can choose wether the cell is 1 or 2 for
selected or unselected.

paul
remove nospam for email addy!



"Pieter van der Walt" wrote:

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