Drop Down List HELP

[coach_veto]

Hi,
My problem sounds very simple but I cannot figure out how to fix it with regular formulas or VBA code.

Example: Let's say I have a drop down list that applies to cells A1:A50. My choices within the list are "United States," "United Kingdom," and "Ireland." Here's my issue: When I pick 1 of my 3 options from the list, I want "US," "UK," or "IR" to appear. So when I click on "United States" from my list in cell A1, I would want "US" to populate instead. If I picked "Ireland" instead though, I would want "IR" to appear and so on...

How can this be done with either formulas or VBA code?

Thanks guys

 

[coach_veto]

yea yours works everywhere Cariberio77...thanks again

 

[Caribeiro77]

You're welcome..