what is the coding for searching. the user only have to key in the beginning letter and the prgm will show all the name with that letter
for example:

after enter the word "P", and click the ok button, the program will show all the name with beginning with "p"

Hi,

This code will help you

Sub Find()
Dim c As Range
For Each c In Selection
    If c.Value Like "A*" Then
        MsgBox c.Value
    End If
Next
End Sub


-vemaju