Like I said, I know how to do the Data Validation/Choose from Drop-Down
thing... That's not the issue.

I don't know how to be more specific without showing you the Visio Chart I'm
trying to automate, but here's another try:

Q1. Are you, or have you ever been, a Communist?
If "Yes", go to Question 2
If "No", go to Question 4

Q2. Are you ready to renounce your Communism?
If "Yes", go to Question 4
If "No", go to Question 3

Q3. Are you sure?
If "Yes", go to Question 5
If "No", go to Question 4

.... and so on and so on.

The trick is, I don't want the question to appear until it's time to be
answered.

In other words, I only want one question onscreen at a time.

I suspect Excel can handle this?

"Tom Ogilvy" wrote:

turn on the macro recorder and create the data validation for a cell using
the list option with your choices. Turn of the macro recorder and look at
the code. Now use this as the model for creating the pick boxes.

Use the worksheet_Change event to react to a selection for each pickbox and
create the next one, positioning the user at that cell.

Another way would be to create all the boxes and as choices are made, use
the change event to delete the inappropriate ones based on the selection.
Position the user at the next appropriate one.

specific code requires specific knowledge. statements like "a drop-down
pickbox"

and "Question Two appears"

and
"and etc., etc. for seven questions. "

are not statments that provide the requisite detail.

--
Regards,
Tom Ogilvy

"RJB" wrote:

I'd like to set up a spreadsheet whe

- Question One is asked, and yes or no is selected from a drop-down pickbox.
- If "Yes", Question Two appears (with a "Yes/No" box); if "No", Question
Four appears (with a "Yes/No" box);
- For Question Two, if "Yes", Question Four appears, and if "No", Question
Three appears (with Yes/No boxes)...

and etc., etc. for seven questions.

Then, based on the answers, I want to display different solutions. There are
twelve different outcomes.

Thoughts?

(I know how to do the pick boxes, but that's about it. I was thinking I
could do the appearing bit with conditional formatting, but what do I know?)