Use concatenated String as input to Data Validation List

  • Thread starter Thread starter KevinC
  • Start date Start date
K

KevinC

Hello all,

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

Is this possible?

Regards,

Kevin
 
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.
 
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.
Click to expand...

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.
 
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?
 
Back
Top