Thread: [Solved] Drop-Down List: Abbreviation
View Single Post
 
Old 01-27-2016, 01:35 PM
coach veto coach veto is offline Windows XP Office 2010 32bit
Novice
 
Join Date: Jan 2016
Posts: 1
coach veto is on a distinguished road
Default 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
Reply With Quote