View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] shannondanielle0413@gmail.com is offline
external usenet poster
 
Posts: 1
Default Drop Down List - Select Multiple Items

On Wednesday, April 30, 2008 5:00:02 PM UTC-4, Per Jessen wrote:
Hi

If you use a List Box it's possible to allow mulit select.

Open the properties window and find the field MultiSelect and enter the
value to "1 - fmMultiSelectMulti"

Regards,
Per

"VLH" skrev i meddelelsen
...
I need to select multiple items from a drop-down list that I created
because
there are times where more than one item is needed.

For example, my drop-down list might contain the following:
apples, oranges, pears, lemons, mangos

I want the data cell to show that I selected: apples, oranges, pears (for
example).

Is this possible?


I have also been trying to be able to select multiple items from a drop-down menu and have them show up in the same cell and cannot figure out how it is done. Where is the "properties window?" Is this a change that should be applied to the entire document or should the column with the drop-down menu be highlighted when I enter the "1 - fmMultiSelectMulti" value?