View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nancy @ CHR
 
Posts: n/a
Default Allow selection of multiple values in dropdown list in excel

Hello --

We've got no problem in creating a list for a drop down box in Excel and
assigning the list to a cell, etc. but how can you set it so that you can
select multiple values? For example, if the drop down list includes
1,2,3,4,5,6 as possible values, how can I get it to allow me to select 1 and
3 or 1, 3, 5 and 6 all at once (like you would typically expect to do by
holding down the CTRL key while selecting each value)?

Your help will be much appreciated! :-)
Nancy