Select multiple values from a list and display in cell

[SebastiaanWexcel]

First of, hello to all.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I am trying to improve a few excel forms that contain lists of applications and situations. <o></o>
<o></o>
What i am trying to achieve is to have a user select multiple values from a list and have these selections listed in another cell as text separated by a comma. So a user selects for any given application in what situation or situations it is used.<o></o>
<o></o>
So that in the future a filter can be specified that shows all applications that are usable in a specific situation (for instance all applications that are usable in case of 'fire')<o></o>
<o></o>

• Im trying to do it with a dropdown list with multiple selections possible, maybe its wiser to use a dif type of list<o></o>
• Maybe i should list the different situations in separate cells ?<o></o>

<o></o>
<o></o>
Regards,<o></o>
<o></o>
Sebastiaan<o></o>
<o> </o>

 

[Damon Ostrander]

Hi Sebastiaan,

Yes, this can be done. But how to do it depends on whether you are using

1. Data Validation with a list to select the item(s) one at a time;

2. a ListBox control with its MultiSelect property set to 1 to enable the items to all be selected at once;

3. a ComboBox dropdown control to select the item(s) one at a time.

Let me know which you are using and I will provide some code.

Damon

 

[SebastiaanWexcel]

Hello Damon Ostrander, thanks for the reply.

I was planning to use the dropdown list option where i select multiple values from a list.

The Data validation option didnt look useable to me as it could happen that 50+ values needed to be selected.

Regards,

Sebastiaan

 

[Damon Ostrander]

Hi again Sebastiaan,

Okay, then you will need approach 2, and to make it drop down when you select the cell you will need a few lines of code. This is a bit much to try to explain, so I'm PMing you with a solution.

Damon

 

[andrei_iv]

Hi again Sebastiaan,

Okay, then you will need approach 2, and to make it drop down when you select the cell you will need a few lines of code. This is a bit much to try to explain, so I'm PMing you with a solution.

Damon

Hello,

I would like to receive the instructions to do this too. I need to pick from a list the values (more than one ) that i want to appear in one cell.

Cheers,
A.