#1
|
|||
|
|||
Drop-Down List: Abbreviation
Let's say I have a list of countries in my drop down list. Is it possible to spell them all out in the list but when one is selected, an abbreviated version appears in the cell?
For example, if "United Kingdom" is in my list, when I select "United Kingdom", I want "UK" to appear in the active cell. Is there code I can reference to make this possible? (New to VBA & Excel in general) Thanks! Last edited by coach veto; 01-27-2016 at 01:35 PM. Reason: spelling error |
#2
|
||||
|
||||
Yes, as long as you have a lookup table somewhere for the values. Can you post a sample workbook for us to see your layout?
|
Tags |
drop down lists, vba |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to import list from Excel into drop-down list into word | ahw | Word VBA | 43 | 02-28-2020 08:11 PM |
Is there a way to derive the abbreviation from their full words spelling? | Jamal NUMAN | Word VBA | 28 | 01-16-2018 01:00 AM |
Drop Down List Help | ksigcajun | Word | 3 | 05-09-2014 05:35 AM |
Drop down list, Can it be done??? | garethreid | Outlook | 0 | 08-09-2012 06:08 AM |
Automating an address from an Abbreviation | Panzer | Word | 0 | 04-12-2010 06:11 AM |