Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find number - where did I go wrong?
I've got a list of ±4500 employees, each with a unique number. The following
macro almost fit my needs: Public Sub findEmployee () Dim foundCell As Range Dim Response As Variant With ActiveSheet Response = InputBox(prompt:="Employee number ?" If Response = ""Then Exit Sub If Not (IsNumeric(Response))Then MsgBox "You did not key in a NUMBER!" Exit Sub Else Set foundCell=.Range("a4:a5000").Find(what:=Response) If foundCell Is Nothing Then MsgBox "The number does not exist" Else foundCell.Activate End if End if End With End Sub I've tried to include MatchCase:=True, however the number 60 is nt allocated to an employee, if I key in 60 ' it activates employee 160 which does exits. Where did I go wrong ??? Please help me. Thank you -- HJN |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find number - where did I go wrong?
Try using LookAt:=xlWhole in the Find call.
Rick "Hennie Neuhoff" wrote in message ... I've got a list of ±4500 employees, each with a unique number. The following macro almost fit my needs: Public Sub findEmployee () Dim foundCell As Range Dim Response As Variant With ActiveSheet Response = InputBox(prompt:="Employee number ?" If Response = ""Then Exit Sub If Not (IsNumeric(Response))Then MsgBox "You did not key in a NUMBER!" Exit Sub Else Set foundCell=.Range("a4:a5000").Find(what:=Response) If foundCell Is Nothing Then MsgBox "The number does not exist" Else foundCell.Activate End if End if End With End Sub I've tried to include MatchCase:=True, however the number 60 is nt allocated to an employee, if I key in 60 ' it activates employee 160 which does exits. Where did I go wrong ??? Please help me. Thank you -- HJN |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace is going wrong in some cases | Excel Discussion (Misc queries) | |||
How to stop Excel from doing wrong Find/Replace | Excel Discussion (Misc queries) | |||
Wrong Week number | Excel Worksheet Functions | |||
FIND method doesn't work in UDF. What's wrong with this code? | Excel Programming | |||
Can anyone find what is wrong with the following? | Excel Programming |