Dear All,
I am creating a survey where I need to disable the second group of option buttons based on response in first group. If user selects 'NA' radio button, all options in second group should be disabled.
My worksheet looks like this ..(attached worksheet).
Response 1 Response 2
Attribute 1 (Option buttons) (Option buttons)
Q1 1 2 3 4 NA 1 2 3 4
Q2 1 2 3 4 NA 1 2 3 4
Attribute 2
Q3 1 2 3 4 NA 1 2 3 4
Q4 1 2 3 4 NA 1 2 3 4
If NA is checked in response 1.... then all corresponding options in response group 2 should get disabled.
Unable to upload my workbook as file, as this forum
Thanks for reading and look for your help (VBA code).
I am creating a survey where I need to disable the second group of option buttons based on response in first group. If user selects 'NA' radio button, all options in second group should be disabled.
My worksheet looks like this ..(attached worksheet).
Response 1 Response 2
Attribute 1 (Option buttons) (Option buttons)
Q1 1 2 3 4 NA 1 2 3 4
Q2 1 2 3 4 NA 1 2 3 4
Attribute 2
Q3 1 2 3 4 NA 1 2 3 4
Q4 1 2 3 4 NA 1 2 3 4
If NA is checked in response 1.... then all corresponding options in response group 2 should get disabled.
Unable to upload my workbook as file, as this forum
Thanks for reading and look for your help (VBA code).
Last edited:
