How do i create a multiple choice drop down list

[Piper]

I have been trying to put together an Excel Sheet giving multiple answers on
a drop down table. Any suggestions would be very much appreciated. Thanks A.

 

[Debra Dalgleish]

You can use Data Validation to create a dropdown list. There are
instructions in Excel's Help, and here:

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

 

[Piper]

You can use Data Validation to create a dropdown list. There are
instructions in Excel's Help, and here:

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



--
Debra Dalgleish


Thanks, but can i choose more than one of the drop down options at the one time?

 

[Tushar Mehta]

I have been trying to put together an Excel Sheet giving multiple answers on
a drop down table. Any suggestions would be very much appreciated. Thanks A.

You can set MultiSelect for a *listbox,* but you will have to write VBA
code to manage the selections. For more check XL VBA for MultiSelect
and/or ListBox.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions