![]() |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#7
|
||||
|
||||
|
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.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Auto create new worksheet when select option from drop down list | JANET JONG | Excel Programming | 1 | 08-01-2018 07:13 AM |
| Select multiple items from a drop down list | ConfuddledOne | Excel Programming | 0 | 01-30-2017 08:13 PM |
| Returning a specific value when item is selected from a drop-down list | J Press | Excel | 4 | 09-10-2012 06:12 AM |
| Show the first item of a drop-down list instead of a blank | Pragabhava | Excel | 1 | 12-29-2011 11:48 PM |
Automatically select first item in drop-down?
|
flackend | Excel | 4 | 08-29-2011 02:07 PM |