Hi All,

I have designed a form in excel with radio buttons 'Yes' And 'No'

How can I fill a cell with Yes if 'Yes' Radio button is selected and No if
'No' Radio button is selected?
Their Inputs of Yes and No are saved on an excel sheet, How can I progam it
such that every record is saved and displayed in Next cell

For eg: If on form I have a Question like:

Are you a Male?
o Yes
o No

The results are exported on excel sheet like:

User Inputs(column header)

Yes
Yes
No
Yes
No
No

Thanks is Advance