Group Box with Option Buttons

Dear Forum,

I have not used Option-Buttons at all and hence do not know how to use them...Can someone please explain how do I set-up a Group-box with a Text value and 5 option buttons..

Application:
I have an assignment where Im preparing a Questionnaire each question having 5 options and these options need to be radio-buttons..as the Test is going to be Time-Bound...

Now, someone please explain me how do I set-up the Group-box and the Options buttons and how do I link the results, I have tried to google however in vain...please explain me how do I counter the wrong answers and How do I use the same options buttons for more than one question?

I am sorry I have no file to attach on the same as I would begin my work after I get an idea..

Warm regards.
e4excel.

Dear Forum,

Is there anyone who can pleas e help or guide in this path of Option Buttons as Im not able to follow head or tail from the info provided on various sites.

Please can someone atleast show how to just set-up the Group for Option Buttons?

Dear Forum,

I have managed to learn something more about Grouping Radio Buttons in a Group-Box but the question on re-using is still unanswered...

Please find the attachment to understand the requirement..

In the Sheet Questionnaire , I formatted the Row to accomadate the Question and the Group Box containing 5 Radio Buttons..

Now I have used VLOOKUP in Cell $B2 based on the Value in Cell $A2 to get the question populated from the Database Sheets...

I have linked the Option Buttons to the Cell $C2 for the Selection result to show-up...

Now when I tried to Copy the entire Structure and pasted all the Option buttons refer to the same Cell $C2 whereas i want it to be $C3,$C4, so on so forth...As I am not sure how it can be done in an efficient manner I had to manually change the Lineked Cells Individually for every Row and then Group the Group box which is very tedious incase of a better un-explored way of which I am unmindful.....

This would make it easier to be copied and pasted...

So please help me on this....

Originally Posted by protonLeah

Format the database option columns as text and not as General or Number

Thanks a lot ProteanLH, it worked brilliantly..!

Now when I tried to Copy the entire Structure and pasted all the Option buttons refer to the same Cell $C2 whereas i want it to be $C3,$C4, so on so forth...As I am not sure how it can be done in an efficient manner I had to manually change the Lineked Cells Individually for every Row and then Group the Group box which is very tedious incase of a better un-explored way of which I am unmindful.....

This would make it easier to be copied and pasted...

How do I also have this text-box refer to different values while using the structure, is it that I have to individually point them to a particular cells and do this rigorosu exercise for each and every Text-Box that I use....

Originally Posted by protonLeah

Sorry, I don't know of a way to automatically generate your questionnaire sheet.

No issues at all!,

Thanks a lot for the help...

SO that means I have to handle each and every Radio-Button and ext-Box..
i.e. Link Each and every Option Button individually to the deisred though the Radio-Button is always going to increment by Row as all the Option Buttons for a single question would have only linked cell and in the case of the Text-box it will reffering to each cell..


Warm Regards
e4excel

Dear Forum,
If anyone has any other efficient ways please provide a suggestion to make it more user-friendly.