|
|
#14
09-21-2018, 03:26 PM
|
||||
|
||||
If you click on the dropdown and click on Developer|ControlsProperties, then select an entry's display name to edit, you'll see the additional details stored in that item's 'value' field. Similarly, if you click on 'Add' to add another item, a dialog will pop up asking you to supply the display name and value. No VBA is needed to do that setup.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Drop down selection which influences value in an adjacent column | lyndap2 | Excel | 1 | 08-06-2018 12:08 PM |
| Formula to check combinations of values in one column to find match from another column | kong1802 | Excel | 1 | 06-15-2018 05:26 AM |
| Drop down list to overlay column of cells with different formulae | TomJ | Excel | 0 | 12-19-2015 08:55 AM |
| How can I temporarily break a 3 column format in order to type a single column paragraph | William P | Word | 1 | 01-04-2015 06:40 PM |
| drop down menu that control filter on other column | massi | Excel | 0 | 08-24-2010 01:13 PM |
Drop down options in Column A, populates column B
Windows 7 64bit 
Office 2010 32bit
Threaded Mode