| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enter data for a question with multiple options?
My instructor wants me to enter answers to questions with multiple possible
answers into one cell. Im confused about how to set the variable and setting the answers to if the choice was selected or not. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I enter data for a question with multiple options?
Maybe this will do what you want.
Debra Dalgleish has a sample workbook with DV dropdown list and code to allow multiple selections fro a list. DV0017 - Select Multiple Items from Dropdown List-- Select multiple items from a dropdown list; an event macro stores selections in adjacent cell, or in same cell. DataValMultiSelect.zip 18kb updated 22-Feb-07 http://www.contextures.on.ca/excelfiles.html#DataVal Gord Dibben MS Excel MVP On Tue, 4 Mar 2008 14:41:04 -0800, InstantNoodleKing wrote: My instructor wants me to enter answers to questions with multiple possible answers into one cell. Im confused about how to set the variable and setting the answers to if the choice was selected or not. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If two Columns have Data enter the Amount Question! | Excel Discussion (Misc queries) | |||
| How do I enter the same data no multiple cells with current data? | Excel Worksheet Functions | |||
| Data Validation - Multiple Options | Excel Discussion (Misc queries) | |||
| data validation - select multiple options? | Excel Discussion (Misc queries) | |||
| enter data into multiple formulas at once | Excel Worksheet Functions | |||
Linear Mode
