Siple Question I think????????

[bfraser]

I can create a list box no problem, but how do I code a cell to list 2 options but only populate the cell with one of the options when selected?

Example:
When I select cell G3 I need a drop down list to appear that shows both an abbreviation and a name, such as

SK Saskatchewan
AB Alberta
BC British Columbia

But when I choose the AB Alberta option, I only want the cell to be populated with the abbreviation AB

How would I go about doing this? What would I have to type in cell G3?

 

[AlphaFrog]

• Put your drop down list in G3
• Right-click on the sheet tab and select View Code in the pop up menu
• Paste the code below in the VBA edit window.

Private Sub Worksheet_Change(ByVal Target As Range)
    
    If Target.Address = "$G$3" Then
        Application.EnableEvents = False
            Target.Value = Left(Target.Value, 2)
        Application.EnableEvents = True
    End If
    
End Sub