Data Validation: Store cell address instead of value in the cell?

[Guest]

I have a list that is used to force entry of specific values into a range of
cells. However, instead of storing the user-selected value, can I store the
cell address (e.g., =E3), while displaying the selected value?

For example, allowed values are stored in E3:E5 ("Yes", "No", "Maybe").
These values should be entered into A1:A10. The dropdown selection list in
A1:A10 should read Yes No Maybe (in a vertical list, of course). Can the
actual contents of A1:A10 be the cell addresses, in this format: =E4

I hope I've made my situation clear enough. I have a large, complex Excel
application that will definitely benefit from a solution to this issue.

Thanks,
Bill

 

[Debra Dalgleish]

You could use programming to change the selected value to a formula, or
you could use a data validation dropdown to add a simple formula to the
cell. But with normal data validation, you can't store the cell address
of the selected valued.