Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question on Forms and functionality of macros
Hi,
I have a client who would like for me to develop a spreadsheet that would ideally consist of a successive set of forms - each one of which would have a quetion. What would happen is that the user would answer the question on the first form and then based on their answer, the next form would come up with a new question. In total, there would be 30-50 questions. Also based on the results of each question would be a calculation which occurs (ie - if the user answers "No" to question 1, then perform calculatoin A+B-C; if the user answers "Yes" to question 1, then perform (2*A)/(B+C)). Ultimately, a set of data will be derived from the users full set of answers and there will be graphs generated from this data. I have the following questoins based on these requirements: 1 - Is it feasible in your mind to have 30-50 forms which are triggered by the answer to the preceding question? 2 - Is it possible to have a macro open up a powerpoint file and copy graphs from Excel into this file? 3 - Is there any other software (MS or other) that you think would better suit these requirements? I appreciate your input! Rob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros, Forms, & Protected Worksheets..... how would I... | Setting up and Configuration of Excel | |||
Excel forms in macros | Excel Discussion (Misc queries) | |||
Forms and Macros | Excel Programming | |||
Question about XML functionality in Excel 2000/XP | Setting up and Configuration of Excel | |||
Question about XML functionality (add-ons?) in Excel 2000 & 2002 | Excel Discussion (Misc queries) |