I am looking to create a tool that will allow a user to click on a button
which wil ask certain questions and depending on the answers ask other
questions until it reaches a conclusion.

i have been toying with message boxes, but i am not sure this is the best
way to proceed.

any suggestions?? also any tips for places i can 'steal' code from.

ta, andrew

I think a userform is a better solution here; I envision a form that has a
text box at the top for instructions and the question to be answered and
either a list/combobox or radio buttons for the answers. When the user
selects an answer the info on the form could change dynamically (through your
code) to list the next appropriate question in the textbox and the next set
of answers to choose, and so on until the final answer is determined. You
would have some work to do to populate the form with the proper questions and
answers (and perhaps to change the number of answers available from one
question to the next), but I think using messageboxes would make that even
more cumbersome.

If it were up to me, I would probably put the list of questions, answers,
and a pointer to the next question in a list on one of my worksheets to use
as a sort of database to use to create the form and modify it on the fly - it
would save on hard-coding the questions and answers into my code and would
make modification easier down the road - e.g:
Question1 Answer1A 2 Answer1B 3 Answer1C 4
Question2 Answer2A 5 Answer2B 6 Answer2C 7 Answer2D 8
....
- This would indicate that if user chooses AnswerA to question 1, go to
question in row 2, if the answer to question 2 was c, goto question in row 7,
etc...
- K Dales


"westg" wrote:

I am looking to create a tool that will allow a user to click on a button
which wil ask certain questions and depending on the answers ask other
questions until it reaches a conclusion.

i have been toying with message boxes, but i am not sure this is the best
way to proceed.

any suggestions?? also any tips for places i can 'steal' code from.

ta, andrew

Hi Westg,

any tips for places i can 'steal' code from.

The NG archives provide a pre-eminent source.

Also see:

http://www.cpearson.com/excel/topic.htm

http://www.contextures.com/tiptech.html

http://www.rondebruin.nl/

http://www.mvps.org/dmcritchie/excel/excel.htm

http://www.j-walk.com/ss/excel/tips/index.htm

http://www.j-walk.com/ss/excel/links/index.htm

http://www.dicks-blog.com/

http://www.erlandsendata.no/english/

http://www.mcgimpsey.com/excel/index.html

http://peltiertech.com/

http://www.xldynamic.com/source/xld.html


The above sites provide links to many other useful resources.


---
Regards,
Norman



"westg" wrote in message
...
I am looking to create a tool that will allow a user to click on a button
which wil ask certain questions and depending on the answers ask other
questions until it reaches a conclusion.

i have been toying with message boxes, but i am not sure this is the best
way to proceed.

any suggestions?? also any tips for places i can 'steal' code from.

ta, andrew