What I'm trying to do is create vba user interaction by asking the the user to answer a series of yes or no questions via input message boxes or yes or no buttons. For example, one question could be,"Is it cold outside?" If the user responded yes then the next question could be, " Is it snowing?" If no the next question could be, " Is it hot?". The possibilities are endless but I'm having trouble getting started. Any suggestions?
You might want to look at creating a UserForm rather than a series of inputboxes. In addition you would use a "helper" worksheet which would house your question and answer tree path. With that being said what you want to accomplish is not for the novice. It sounds to me like an intermediate to advanced level project. Best of luck
If you are happy with my response please click the * in the lower left of my post.
Random questions picked from a predefined possible list of questions?
Sounds like a nice challenge. Have you decide how you want to record the given answers?
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Not random questions, there will be a predefined starting question but the following questions will depend on the users yes or no answers. Every question and every answer will be predefined but by the series of yes and no answer the user will only see one of the answer.
That will mean that only one question is show at the time and depending on the user's Yes / No the next question will be displayed?
All you need is a userform with one label filed for the question and two option buttons for a Yes and a No.
You will have to figure out the strategy for which question to show after every answer.
I've thought about this for a few days and I can now better explain what I want to do with a working example of what I'm looking for:
My goal is to make many many questions, do you see a better way to do this or foresee any complications with this method?
Please Login or Register to view this content.
I don't forsee problems but it is quite static and any changes you would like to make in the future like adding questions or modifying question makes it difficult.
I have an idea I will try to work out and then I'll post it to you.
Just give me a day or two.
I would separate the data from the process, something like this:
Row\Col Did it rain? N Will you water the plants? **NN Well, you should. **NY Thank you. Y More than an inch? **YN More than a half inch? ****YNN Give the plants a little snort ****YNY Water the plants **YY No need to water.
(The asterisks are how indents appear on the board, and are there for readability; they are not asterisks or any other character.)
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Sorry that I haven't added any comments to the vba code but this is a little setup
It's bed-time here, I'm just posting the file and off to bed.
BTW, You could implement @shg 's idea about the YYY and YYNN etc. in this one too,
Used shg's table and my form
It works now, made a small mistake.
Added a 2nd category
Thank you very much, I can see where this method will make a lot of difference once the number of questions become many. I appreciate your time, now I'm going to study the code to see if I can figure out how it works, I may have a few follow up questions.
No problem, you know where to find us / me
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks