Disable option buttons - Need VBA to disable second group of option buttns based on response in the first

[ex123]

Dear All,

I am creating a survey in Excel 2010, where I need to disable the second group of option buttons based on response given/clicked in first group of option buttons.

What I want: If the user selects 'NA' radio/option button, assign its value as '0', and disable all corresponding options in the second group (option buttons 2).

My worksheet looks like this ...

	1	2	3	4	NA	1	2	3	4
Attribute 1
Question 1
Question 2
Attribute 2
Question 1
Question 2
Attribute 3
Question 1
Question 2

<tbody>
[TD="colspan: 5"] Option buttons 1
[/TD]
[TD="colspan: 4"] Option buttons 2
[/TD]

</tbody>

If only 'NA' is checked in Option buttons 1 then all corresponding options group 2 should get disabled, else user should be able to check/choose option in both groups of option buttons.

I have already created the option groups but unable to disable based on selection in the first group)

Unable to upload my workbook as file attachment in this forum.

Thanks for reading and look for your help (<acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> code) to above problem.