Data Verification

[liongil]

How can I put in The Data Verification (List) Record Source
A Cell that contains string like "A,B,C" and the returned List would be-
A
B
C

and not the string "A,B,C" as chose.?

 

[jfish1288]

Try typing your list with A, B, and C each in its own cell and then selecting that range as the source

 

[liongil]

i have a function that returns a string in that format (a,b,c) into that cell.
and that cell changes constantly.