Use concatenated String as input to Data Validation List

[KevinC]

Hello all,

I would like to use a concetenated string to populate a data
validation list.

Is this possible?

Regards,

Kevin

 

[Dave Peterson]

Are you using a range as the source of the validation list?

If yes, you can use a formula in any of the cells in that range to concatenate
the values from any other cells.

 

[WallyWallWhackr]

Are you using a range as the source of the validation list?

If yes, you can use a formula in any of the cells in that range to concatenate
the values from any other cells.

I use named ranges for drop downs all the time. Filling said range can
happen in any manner.

http://office.microsoft.com/en-us/t...resistor-value-decoding-tool-TC101945032.aspx

http://office.microsoft.com/en-us/t...crement-selection-revision-2-TC030008308.aspx

On the time sheet workbook, the time increment selection is user
specified. All without any programming need as yet.

 

[KevinC]

What I would like to do is have all my list values stored in one cell
as Item1,Item2,Item3 etc

I would like to the reference this single cell and then the list Items
would appear ina drop down as:

Item1
Item2
Item3

The reason I am trying to do this is that I have many cells to
populate - the following thread goes into a bit more detail:
http://www.mrexcel.com/forum/showthread.php?p=2388936#post2388936

 

[KevinC]

What I would like to do is have all my list values stored in one cell
as Item1,Item2,Item3 etc

I would like to the reference this single cell and then the list Items
would appear ina drop down as:

Item1
Item2
Item3

The reason I am trying to do this is that I have many cells to
populate - the following thread goes into a bit more detail:
http://www.mrexcel.com/forum/showthread.php?p=2388936#post2388936

 

[The_Giant_Rat_of_Sumatra]

You can create a drop down from a column of cells, but do they really
all need to be in one cell?

If so, you could concatenate (parse?)that list, then populate a named
range with those values, and make the drop down refer to the named range,
whether there are any values in the cells or not.


What is the function to cut your comma separated list into each of its
constituents in a vertical one item per ROW single column fashion?

With that it would be easy. Is it "FIND"? I can do it with a wizard
but I want to make a button that does it from your list. Again, why do
you need to make the desired menu list that way?

 

[WallyWallWhackr]

It still needs the parsing engine.

http://www.mediafire.com/file/tfvy2s9atb8gg7v/menupicker.xltx