I am making a survey and I need to have drop down boxes where more than one
answer can be chosen. Is this possible. If so how do I do it?

Maybe you could use a Listbox from the Forms toolbar or from the Control toolbox
toolbar. Each can be set to allow multiple selections.

And each requires code to retrieve the values (and the code for each type of
listbox is different. So if you need help using one of these, you'll want to
specify which Listbox you used.)

megs wrote:

I am making a survey and I need to have drop down boxes where more than one
answer can be chosen. Is this possible. If so how do I do it?

--

Dave Peterson

Hi Megs,
Make a list of what you would like to be able to choose in an unused part of
your worksheet. Enter only one "answer" in each cell. Now highlight the
cells that you would like to have the drop down appear, click on data, then
click on validation. In the validation criteria drop down, choose "list". In
the source area, click on the worksheet icon to the right, it will take you
back to your worksheet, now highlight the cells that contain your answers &
press enter. Now when you click in the cell, a drop down will appear for you
to choose your answer from. You can also set a customized input data message
& alert in case someone tries to enter data other than what is in your
"list", do this under the second two tabs in the validation screen.

Hope this helps

"megs" wrote:

I am making a survey and I need to have drop down boxes where more than one
answer can be chosen. Is this possible. If so how do I do it?

Another option is to do this with a data validation dropdown list and
programming. There's an example he

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

Under Data Validation, look for 'DV0017 - Select Multiple Items from
Dropdown List'

megs wrote:
I am making a survey and I need to have drop down boxes where more than one
answer can be chosen. Is this possible. If so how do I do it?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

MESSAGE for DEBRA DALGEISH

I have copied and used the code you provided. I changed it slightly for it to be applied to more than one column using the option Or (so now it is not only applied to column 16, but also to a number of other columns). I need help because now it is applying to ALL columns with a list option, even when I want some of these only to allow for ONE option to be picked and not multiple ones. What am I doing wrong? Could you help?

Thanks

Larocha

MESSAGE for DEBRA DALGEISH

I have copied and used the code you provided. I changed it slightly for it to be applied to more than one column using the option Or (so now it is not only applied to column 16, but also to a number of other columns). I need help because now it is applying it to ALL columns with a list option, even when I want some of these columns only to allow for ONE option to be picked and not multiple ones. What am I doing wrong? Could you help?

Thanks

Larocha