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...
sandrosg Another work-around could be to use TEXTJOIN to create the drop down list as "A to B; 20" etc., as shown in G6:G8,
And then you can use a not too complicated formula (G13) to SUM the values from the selected tracks.
- Hi Riny, this comes pretty close to my challenge. Is there any way to display just the numeric values in 1 cell ?I guess then it's getting more complex...anyway thx so far...
Here is an example using a combo box and VBA. You'll have to allow macros.
HansVogelaar Dear Hans, thx for the example...however on my Excel for Mac it doesnt work due to the missing Active X support...gonna try that later under W11.. Thx Sandro
