Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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 |
#3
![]() |
|||
|
|||
![]() "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? |
#4
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Drop list affected by previous choice | Excel Worksheet Functions | |||
Drop down list with multiple choices | Excel Worksheet Functions | |||
how do i create a find function for an excel drop list? | Excel Discussion (Misc queries) | |||
How do I create a drop down list in Excel 2003 | Excel Discussion (Misc queries) | |||
Is there a way to create a drop-down list of links in Excel? | Excel Worksheet Functions |