Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VBA Help with Form
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Help with Form
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a template form, advance a form number everytime you open | Excel Discussion (Misc queries) | |||
Call user form from ThisWorkbook; close file if form closed | Excel Programming | |||
Pass variable from form to form to form | Excel Programming | |||
Strange issue freezing parent form when unloading a child form | Excel Programming | |||
Is it possible to open the VBA form with a link in a sheet and to pass variable from a cell to the VBA form? | Excel Programming |