Change a basic data validation list into a list that can be scroll by a letter and then scroll thru all names beginning with that letter.

[NY_Rican]

Change a basic data validation list into a list that can be scroll by a letter and then scroll thru all names beginning with that letter. If I hit the letter "S", I want to jump to the first name beginning with the letter "S".

 

[Peter_SSs]

See if this helps.

 

[NY_Rican]

See if this helps.

Thank you, sometimes I miss the forest for the trees in the way !!! In any event, your link sent me to create a combo box, and everything is great. However, a few days ago "Mumps" gave me a VBA code to allow me to choose a name from the data validation list and it would populate the names ID number into the cell to the right. When I activate the combo box, choose a name and hit enter, the ID does not populate. Therefore, I have to choose the name again without the combo box. Make sense ??? See the code below..

VBA Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.CountLarge > 1 Then Exit Sub
If Intersect(Target, Range("A:A")) Is Nothing Then Exit Sub
Dim rName As Range
Set rName = Sheets("Sheet1").Range("A:A").Find(Target.Value, LookIn:=xlValues, lookat:=xlWhole)
If Not rName Is Nothing Then
Target.Offset(, 1) = rName.Offset(, 1)
End If
End Sub

Any suggestions ???