Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to revive this question... Help :)
I have a list of question in 2 sheets within the same workbook.
Those questions are risk evaluation for projects but depending on 5 criterias, project risk evaluation is modulated in 3 categories : low, medium and high risk. In the case of Low risk, the first sheet is skipped altogether and only certain questions on sheet 2 must be answered. For medium risk, certain question of sheet 1 and 2 must be answered For High risk, all questions of both sheets must be answered. For low and medium risk, the questions are not necessarely sequential, i.e. Q1, 3, 34, 45, etc... Once answered, I already have a vba code taking all High risk evaluation questions and copy them into a third sheet which is the contingency planning for those risk. MY PROBLEM / QUESTION : When the Evaluation Agent comes in the workgroup, I want to have a first page interface where he must first answer those 5 questions to evaluate which category the project falls in. Then automatically or by the push of a button, a questionnaire will popup asking all questions identified in the appropriate risk group. Once the questionnaire is answered, the vba code for contingency planning is automatically executed and the agent is presented with this 3rd sheet. Can this be done ? (I suppose yes) How ? Is there already an example somewhere where I can elaborate and taylor to my need ? Of course, results should be copied into each appropriate cells. Down the road, I plan to print a summary of those questions/answers but I'm not there yet. Thanks for any help you can provide me ! |
Thread Tools | Search this Thread |
Display Modes | |
|
|