Hello all,

I am trying to create a questionnaire using a vba userform - there are about 17 questions, each with multiple options (Yes/No/Unsure for part 1 questions, part 2 questions have Low/Med/High/Unsure) - please see attached...

How do I best determine the value of the response for each question?

I have already grouped each set of Y/N/U with a unique Group name - how do I output to answer sheet what is the selected option for Q1?

Because there are 17 questions, I am trying to write some efficient code, rather than one really long if statement.

Any suggestions?

Thanks,

Ian

Example 1.PNG