maybe something like this
dim c as control
for each c in controls
if typename(c)="Option Button" then
if c.value="Yes" then
countyes++
endif
endif
next

(I'm not 100% sure of the typename, but something like this should work)

J

"naddad" wrote:


Hi,

I have a form in which I have yes/no questions. The user has to answer
the questions and at the end i need to display the score.
So I have several groups of 2 option buttons (Yes/No) and I would like
to know how I can find out which option is selected from a group.
Say group1 has "Yes" selected, I would like to have something like the
following:


Code:
--------------------
if group1.selected.label = "Yes" then countYes++ end if
--------------------


Can anyone help me?

Also, while I'm at it, I have about 25 questions so I have 25 groups.
Is there a smarter way to calculate the total score than type in the
line above for each and every group manually?

Thanks all,


--
naddad
------------------------------------------------------------------------
naddad's Profile: http://www.excelforum.com/member.php...o&userid=29817
View this thread: http://www.excelforum.com/showthread...hreadid=495201