I am making a Questionnaire where each question has 5 options..
Each option has a Radio-Button and Text-Box to store the value of the Option...
Ex: What is 2 raise to 10? 0A.5120B.2560C.10240D.20480E.NA
In the above the zero "0" depicts an Radio Button with 5 choices from A,B,C,D and E...
The Boldened Red i.e 512,256,1024,2048 and NA are all the actual answers and it would change depending on the questions chosen for the Test.
Several questions would be stored in a Sheet called Question-Database with the Questions and their 5 options next to it in adjacent Columns..
Now In another Sheet called Questionnaire, I would be selecting any Question No and the Question i.e. Q1.What is 2 raise to 10?
would be pulled by VLOOKUP when I put 1 in the adjacent cell?
But I also need to have the relevant options shown below the selected question which would be different for each question?
So I need some mechanis which updates the Radio-Buttons Labels correctly.? Since I'm using Control Text-Boxes I would like to know how to get dynamci values for the same?
I am willing to use any other approach too if thats feasible...
Hope I have been able to explain the requirment correctly..