Saving Survey results with Radio Button

[TheRevenant]

So I have followed this:
https://www.youtube.com/watch?v=MZx79FdKveY
and this:
https://www.youtube.com/watch?v=d3BIu4GrWcM

What is the VBA script to save the selection in the multiple choice options? See my attached Excel sheet.

Thanks for your help.

Too bad I couldn't find this on YouTube.

[Trebor76]

Hi there,

In the following I have split the question number and result into two variables so can do with them as you please (I have just put them in a message box):

Please Login or Register  to view this content.

Too bad I couldn't find this on YouTube.

Thank goodness for forum's like this then

Regards,

Robert

[TheRevenant]

Hi Trebor, how do I linke the button to the script? Sorry I'm new with VBA.

In Dim btnMyButton As OptionButton
is btnmyButton the name of my nutton?

But button is called CommandButton2

Private Sub CommandButton2_Click()

End Sub

[Trebor76]

Refer attached where I've linked my macro the the Submit button (the type of which I also changed from an ActiveX control to a form control). When you click that button the code loops through all the buttons and alerts you if a button has been selected (I do this via a variable called btnMyButton).

[TheRevenant]

Instead of the box prompt "The value for question 1 is 1" how could I add all the results and divide them by the number of questions. Then save it into another tab?

Suppose I want to add a comment box such as:

"Please rate your comments:"

How would be able to save the results in another tab?

Thank you,

[Trebor76]

Have a look at the attached where the number of selections (i.e. radio buttons selected) are divided by the question value in Sheet1. This assumes only one radio button per question can be made and that a selection of N/A equals a zero value.