Thread: [SOLVED] 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 here:

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 here:
>
> 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 <472A62FC-9170-424D-933A-96C095A25279@microsoft.com>,
Piper@discussions.microsoft.com 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