how do u set up multiple choice answer buttons/dots?
 

i'm using Excel 2003 and making a mulitple choice questionaire and need to
add buttons to that the user can choose their answer, it's usually a circle
icon in when you select it the dot fills in colour. Not sure how to do this
or if Excel can do this? Can you help??

how do u set up multiple choice answer buttons/dots?
 

pam123 Wrote:
i'm using Excel 2003 and making a mulitple choice questionaire and need
to
add buttons to that the user can choose their answer, it's usually a
circle
icon in when you select it the dot fills in colour. Not sure how to do
this
or if Excel can do this? Can you help??
Hi Pam
If you mean the option buttons, then you can do this
bring up the forms toolbox and click on the circle with the dot, go to
where you want to place the option and cick on the left button on the
mouse and draw it in
click on the option button on the forms tool bar again and draw the
second button beside it
right click on the 1st button and select format control select select
control tab, for cell reference we'll call it C1 for this example,
do the same for the cecond option button cell reference C1
assuming for this example you are placing the option buttons in cell
A1
in B1 enter this folmula
=if(C1=1,"Yes","No")
now test it out.


You Might want to look into the checkboxes as a way to do it as well,
you would only require one box if it is checked then yes
dtry it the same way as an option box but the formula needs to be
=If(C2=True,"Yes","")


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=517755