Hi,

I have a drop-down list that uses a named range as input, and obviously has a single cell as its output.

Suppose the user has selected an item from the current drop-down list, and the linked cell contains the index of that item. My issue is that if the size of the named range changes (i.e. such that the position of the originally selected item changes within it), the list in the drop-down box updates, but the integer in the linked cell does not update (even with calculation set to Automatic).

Is there a way to force updating of the linked cell associated with a drop-down box, without the user having to choose a different item in the list and then go back to the original one?

Thanks in advance,
Jeff