Hi. Anyone know how I'd go about taking the currently chosen value from a dropdown
( that is populated from a 'list' on my worksheet ), & storing that in another cell as a text string ?

I cant simply refer to the value in the original cell, ( ie =A1, because its contents is variable as people change the contents of the dropdown )

So the values in my list are A, B, C, D :
I want to store whichever of those values is the current 'choice' in a separate cell, so I can track how many times the contents of the drop down changes.

Hope this explanation is clear enough.

Cheers