N
numbermonkey
I’m advanced at formulas and functions, charts, etc, but NOT ver
knowledgeable on VBA, so I would greatly appreciate your help on a for
(questionnaire) with radio buttons.
The form/questionnaire has 17 questions, with “Yes” and “No” radi
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 o
it. One or the other may be selected (not both)
The combination of “Yes” and “No” selections for the question
determines which Solution is recommended.
On the bottom of the form is an “Evaluate” button that the user select
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”, the
“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 thos
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
knowledgeable on VBA, so I would greatly appreciate your help on a for
(questionnaire) with radio buttons.
The form/questionnaire has 17 questions, with “Yes” and “No” radi
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 o
it. One or the other may be selected (not both)
The combination of “Yes” and “No” selections for the question
determines which Solution is recommended.
On the bottom of the form is an “Evaluate” button that the user select
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”, the
“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 thos
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