Questionnaire to letter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Elfego Baca - 24 Mar 2007 22:08 GMT

I have a questionnaire that I have written on Sheet1 of an excel
spreadsheet.

1. Do you have a radio Yes/No
2. Do you own a TV Yes/No
3. Which of the following do you own? Iron, Ironing Board,
Microwave, Refrigerator, Stove

Sheet 2 would use the information entered in Sheet 1 to create a letter
that might says the following:

Mr. Jones owns a radio and a TV. He also owns an iron and a stove.

If Mr. Jones owned a radio but not a TV. The first sentence would say:
Mr. Jones owns a radio but not a TV.

I would use a validation drop down menu for the first sentence but I
can't figure out how to use a drop down menu that would allow me to take
multiple answers to question 5 and make them into an English sentecne
such as:

He also owns an iron and a stove.
He also owns an iron, a microwave and a stove.
He also owns an iron, ironing board, a microwave and a stove.
He also owns an iron, ironing board, and a microwave.

Reply to this Message

Anne Troy - 24 Mar 2007 22:17 GMT

You can try something like this:

=if(isblank(D4),R2&E4,R2&D4"and a"&E4)

Now, R2 might contain "He owns a ..."
So, you see how you can use ISBLANK to determine which cell's text you want
to use.

****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************

>I have a questionnaire that I have written on Sheet1 of an excel
>spreadsheet.
[quoted text clipped - 21 lines]
> He also owns an iron, ironing board, a microwave and a stove.
> He also owns an iron, ironing board, and a microwave.

Reply to this Message

Elfego Baca - 25 Mar 2007 16:18 GMT

isblank does not help much. I tried using the formula exactly as you
typed it and I got an error message. I put words in the D4, E4 and R2
cells and still got an error. The formula should probably be more like
this: =IF(ISBLANK(D4),R2&", "&E4,R2&", "&D4&", "&"and a "&

But that doesn't solve the problem I have. Here I have a single
question: Which of the following do you own,Iron, Ironing Board,
Microwave, Refrigerator, Stove.

The best would be to have a dropdown list in the cell itslef with all
the choices,Iron, Ironing Board, Microwave, Refrigerator and Stove.
However A validation drop down list only allows 1 choice. There is no
real multiple choice dropdown list that is simple to use that I can find.

What I need is a way to create a general question macro that allows for
6 choices or more, and allows the user to check none or more of the
choices and then creates a variable, possibly for each of the choices so
that the checked items can be used elsewhere in the worksheet.

Thus the question"Which of the following do you own,Iron, Ironing Board,
Microwave, Refrigerator, Stove." could have a myriad of possibilities
such as the following:

I own the following items: Iron, Ironing Board, Microwave, Refrigerator,
and Stove.

I own the following items: Ironing Board, Microwave, and Stove.

I own the following items: Ironing Board, Microwave and Refrigerator.

I own the following items: Iron.

Any other possiblities to creating this type of questionnaire?

> You can try something like this:
>
[quoted text clipped - 34 lines]
>> He also owns an iron, ironing board, a microwave and a stove.
>> He also owns an iron, ironing board, and a microwave.

Reply to this Message

Anne Troy - 25 Mar 2007 16:48 GMT

You need a listbox in VBA. Try the Excel VBA or programming group. I'm not
sure what the name of it is. :)
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************

> isblank does not help much. I tried using the formula exactly as you typed
> it and I got an error message. I put words in the D4, E4 and R2 cells and
[quoted text clipped - 68 lines]
>>> He also owns an iron, ironing board, a microwave and a stove.
>>> He also owns an iron, ironing board, and a microwave.

Reply to this Message

Ragdyer - 25 Mar 2007 16:56 GMT

You might explore using 5 cells in a row to contain any, or all, or none of
the choices.
Each one of these cells could be a drop-down, drawing from the same
datalist.

Debra Dalgleish has a procedure on her site for creating such a drop-down,
where, as an item is picked, it is *removed* from the choices available in
the next cell's drop-down.

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

Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> isblank does not help much. I tried using the formula exactly as you
> typed it and I got an error message. I put words in the D4, E4 and R2
[quoted text clipped - 68 lines]
> >> He also owns an iron, ironing board, a microwave and a stove.
> >> He also owns an iron, ironing board, and a microwave.

Reply to this Message

Jon B - 30 Mar 2007 15:21 GMT

How did you get on with this, because I also have a similar problem, in that I would like to be able to pick multiple answers from a dropdown list, without having to use multiple lists?

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

Reply to this Message