![]() |
|
![]() |
|
Thread Tools | Display Modes |
|
#1
|
||||
|
||||
![]()
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 |
![]() |
|
![]() |
||||
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 |
![]() |
flackend | Excel | 4 | 08-29-2011 02:07 PM |