Name checking
 

I had a list in Row A that goes straight down---say 20 given names .
And I am asking the user to input a name.The system checks THE
INPUTtED NAME and then goes to show me if "it is" there or it is
"not" with a message. I am getting some problems with the coding that
I wrote. USing VBA---any help would be good...Thanks...

Name checking
 

Maybe something like this:


Dim r As Range
Dim strName As String

strName = InputBox("Enter a name")

Set r = Range("A2:A4").Find(strName)

If r Is Nothing Then
MsgBox strname & " not found!"
Else
MsgBox strname & " found in " & r.Address
End If




wrote in message
ps.com...
I had a list in Row A that goes straight down---say 20 given names .
And I am asking the user to input a name.The system checks THE
INPUTtED NAME and then goes to show me if "it is" there or it is
"not" with a message. I am getting some problems with the coding that
I wrote. USing VBA---any help would be good...Thanks...




----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----