|
Subject:
|
HOW TO MAKE SEARCHING WITH BEGINNING LETTER
|
|
Posted By:
|
sime_tyres
|
Post Date:
|
1/3/2006 4:20:59 AM
|
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"
|
|
Reply By:
|
vemaju
|
Reply Date:
|
1/3/2006 8:37:27 AM
|
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
|
