How do i create a multiple choice drop down list
 

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 use Data Validation to create a dropdown list. There are
instructions in Excel's Help, and he

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

Piper wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

"Debra Dalgleish" wrote:

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

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

Piper wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

In article ,
says...
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