[numbermonkey]

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.

[GS[_2_]]

I assume that you mean you have designed a worksheet to be used as a
questionaire!

I recommend using a DV dropdown for user choices with 'helper' columns
to render result combinations based on the user's selection. This will
eliminate the need for using controls (and their associated overhead),
simply the process, and provide the same (or better) quality experience
for the user!<IMO

The helper cols (and/or rows) can be hidden so your questionaire has a
cleaner look. Since you are advanced at using formulas/functions then I
expect you will have no problem designing a calc mechanism for which
'solution' to return based on how your helper cells evaluate their
respective DV dropdown selection.<g

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion