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

(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,

Peter

Leave a Reply

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