View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
VLH VLH is offline
external usenet poster
 
Posts: 7
Default Drop Down List - Select Multiple Items

Hello,
Can you instruct me on where to find the "properties window" please?
Thanks!

"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?