I’m advanced at formulas and functions, charts, etc, but NOT very knowledgeable on VBA, so I would greatly appreciate your help on a form (questionnaire) with radio buttons.

The form/questionnaire has 17 questions, with “Yes” and “No” radio buttons, but for the sake of brevity I’ll ask for help for 3 questions, and then just repeat the code (…adjusting for the remaining buttons).

Layout:
3 questions, listed in cells B3:B5

Each question has a Yes radio button and a No radio button at the end of it. One or the other may be selected (not both)

The combination of “Yes” and “No” selections for the questions determines which Solution is recommended.

On the bottom of the form is an “Evaluate” button that the user selects to return the recommended Solution (text string), in cell B6.
So, if Question 1 is “Yes”, Question 2 is “No”, and Question 3 is “Yes”, then “Solution One” is recommended.
If Question 1 is “No”, Question 2 is “Yes”, and Question 3 is “No”, then “Solution Two” is recommended.
If Question 1 is "Yes", Question 2 is "Yes" and Question 3 is "Yes", then "Solution Three" is recommended.
And so on...

If you could also include code that, if selections other than those listed in the code are selected, then “No Solution Found” is returned.

A macro to clear the form would also be appreciated.

Thanks a bunch for your help.