How do I enter data for a question with multiple options?

  • Thread starter InstantNoodleKing
  • Start date
I

InstantNoodleKing

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.
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting question: how to format duration (time spent)? 0
Getting Radio Buttons to work, that are inserted via AutoText 0
How to make repeating drop-down lists? 2
How to Select Multiple Emails using Surface Pen 0
ASK Field Formatting 1
How to create skip pattern in access 2013 form 0
How can I get a Shareable URL via VBA code to a OneDrive image? 0
Copy previous record into form field 0

Top