I have a worksheet with Combobox Form Controls (dropdowns) embedded for which the Input Range is a dynamic named range (not validation dropdown).
When the range change, the values listed in the drop down is modified accordingly, but the linked cell value is not updated even if the displayed value in the drop down is modified.
The workbook should be macro free, so I cannot use VBA to force a refresh of the cell value.
My internet search seems to indicate that it is impossible, but I might have missed something.
There is no external content in the workbook and no links, so refreshing the external link does not help.
The named dynamic ranges are all internal, for example one named range (Choice_List) can refers to
When the cell
Test!$B$2 change the list displayed change accordingly, but if the new list contains fewer elements than the currently selected item index, the drop down will display the last item of the list, and the value of the linked cell won't change.
After changing the max number of items: