Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 =---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
Checking and IF ? | Excel Worksheet Functions | |||
Checking range of cells for entry then checking for total | Excel Programming | |||
I need some checking done | Excel Programming | |||
#NUM checking | Excel Programming |