(Solved) – In Excel, how to I get the value a User has selected from a Data Validation List?


I am completely stuck on an issue with a Data Validation List and would very much appreciate any assistance.

I have the Data Validation List in Cell D10. When the User selects a value, I would like to copy the value to a different cell on the same worksheet (I won’t cloud the issue with why) but whenever I try Range(“G10”).value= Range(“D10”).value, nothing is returned.

As D10 is a Data Validation List, I have also tried using Range(“G10”).value=Range(“D10”).validation.value (from an example code found online) but still nothing is returned.

Is anyone able to point me in the right direction? I feel I must be missing something obvious.

Many Thanks,


Leave a Reply

Your email address will not be published. Required fields are marked *