Microsoft Office Forums - View Single Post - [Solved] Can Select Case be used to defined the Value of an item in a drop down list?

Guessed · 10-08-2020, 01:06 AM

You haven't provided the phone numbers for the SOs anywhere so this is going to be a 'concept' post rather than a pre-rolled solution. Firstly, you populate the text AND the value at the same time

.DropdownListEntries.Add Text:="Joe Blow", Value:="123456"

Now, the bigger question arises of how do provide the lookup values in a sensible layout so it is editable and expandable. Do you have any experience with custom xml? This would require a lot less coding if you had a custom xml file embedded and mapped some of the CCs to that xml data.