Forum Discussion
Dropdown List with "description" and actual "value"
Hi there, I'm facing an issue with a dropdown list/menu. I need to create a simple KM calculation. However the KM(value) need to show its description (characters) in the dropdown menu. Any chanc...
A simple workaround: display a data validation input message:
Result:
Otherwise, you'd either need a more complicated sum formula, or an ActiveX combo box together with VBA code.