Defined Name & Validation Lists

[sanity_1977]

Hi

I am trying to work with validation lists and would like to know if I can somehow make the value in the validation list (C7) equal to the name that is entered into another cell (A7). My reasoning is a little more complicated but the example is simplified and if there is a solution I can implement it into the bigger picture. Doing it the way that is shown in the example forces the list to contain just the one word shown in cell A7 rather than referring to the Defined Name called cases (C2:C4). I'm hoping there is some command I can put the name in cell A7 to indicate it is actually a defined name eg. =command(A7)

Any help would be excellent.

PS. I'm hoping the example.jpg has attached because it ain't showing up in the "preview post"

[VBA Noob]

Try

=indirect(A7)

http://www.contextures.com/xlDataVal02.html#Apply

VBA Noob

[sanity_1977]

Perfect ... Thanks heaps VBA Noob and for such a quick response.

I knew it would be something simple.

[VBA Noob]

No problem

Glad it helped. Anything you need on data validation then just use that link.

Be sure to download the examples for more ideas

VBA Noob