Forum Discussion
sandrosg
Feb 04, 2023Copper Contributor
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
Feb 04, 2023Copper Contributor
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...
HansVogelaar
Feb 04, 2023MVP
Here is an example using a combo box and VBA. You'll have to allow macros.
- sandrosgFeb 04, 2023Copper Contributor
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