Take a look at this page of Debra Dalgleish's website. It shows how to
create a survey form with option buttons automatically with VBA code written
by Dave Peterson:

http://www.contextures.com/xlform01.html

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Proto" wrote:

In working with excel I am trying to use a form with 2 yes or no questions.
I am using option buttons marked yes and no but when I try clicking on them
only 1 of the 4 buttons darkens. I copy and pasted one set and then made a
new button and copy and pasted that. but still only one button will darken
at a time.I would really like each question maked yes or no