Drop-Down List: Abbreviation

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Drop-Down List: Abbreviation

FAQ

Thread Tools

Display Modes

01-27-2016, 01:35 PM

coach veto coach veto is offline

Windows XP Drop-Down List: Abbreviation

Office 2010 32bit

Novice

Join Date: Jan 2016

Posts: 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

Tags

drop down lists, vba

« Previous Thread | Next Thread »

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	27	01-15-2018 01:55 PM
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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:50 AM.