M
megs
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?
answer can be chosen. Is this possible. If so how do I do it?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
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.)
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.)
V
Vera Lemon
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
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
D
Debra Dalgleish
Another option is to do this with a data validation dropdown list and
programming. There's an example here:
http://www.contextures.com/excelfiles.html
Under Data Validation, look for 'DV0017 - Select Multiple Items from
Dropdown List'
programming. There's an example here:
http://www.contextures.com/excelfiles.html
Under Data Validation, look for 'DV0017 - Select Multiple Items from
Dropdown List'