Drop-down Box

[Karen615]

Hello,



Is there a way to create a drop-down list that does the following:

When the user opens the drop-down, you see (for example) AK-Alaska, AL-Alabama, AR-Arkansas, etc. But when the cell is populated, it only returns the two-character state.

Your health is greatly appreciated.
TIA, Karen

[Alansidman]

I am pretty sure that for this to work, you will need to have a combo box linked to some VBA that would include the workbook function =Left

[Karen615]

Thank you so much for your suggestion.

Best,
Karen

[kvsrinivasamurthy]

Worksheet event is used.
Let the validation range is C2:C6.
Select the range C2:C6. select Data Validation in ribbon.
In the Data Validation dialogue box select Error Alert. In Style dropdown select Information. Ok.
Event code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("C2:C6")) Is Nothing Then
Application.EnableEvents = False
Target = Left(Target, 2)
Application.EnableEvents = True
End If
End Sub

How to use worksheet event the code
Right click on Sheet tab --> view code
Visual Basic (VB) window opens.
Paste the code
Close the VB window.
Save the file as .xlsm

[SnakeDoctor]

I would like to be able to make a selection in the drop down, and have it populate the selections abbreviation in the same cell...

https://www.msofficeforums.com/attac...1&d=1730822992

Is this possible?

[Pecoflyer]

Please start a new thread. There was nothing attached either