need more exact search

[reddcannon]

The code below came from you wonderful people at Mr. Excel, however I have one slight problem. If for example I push the button to search for 75 it goes to 275 which is hundreds of rows before 75. And no I cannot change the sort order of part numbers, because they are actually done by name and must remain in the order I have them. Is there a way to get a more accurate search out of this code

Private Sub CommandButton2_Click()
Dim searchthis As String, Found As Range
Me.Unprotect Password:="123"
searchthis = InputBox("Type Name or Number.", "Property Search")
Set Found = Range("A:A,C:C").Find(What:=searchthis, LookIn:=xlFormulas, LookAt:=xlPart)
If Not Found Is Nothing Then Found.Select
Me.Protect Password:="123"
End Sub

 

[p45cal]

try changing xlPart to xlWhole?

 

[reddcannon]

Thanks so much, I have sent back a thank you everytime, I am new to this site and cannot find where to go to say problem resolved etc. Can you guide me.

 

[p45cal]

Thanks so much, I have sent back a thank you everytime, I am new to this site and cannot find where to go to say problem resolved etc. Can you guide me.

That's my strap line, it appears on all of my posts.
It's under thread tools I think, but not visible in Firefox, but visible in IE.

 

[reddcannon]

Oh, ok thanks so much, yes I tried that under Thread tools and all that is there is 3 choices.
Show printable version
Email this page
Unsubscribe from this thread.

You folks are amazing. In fact after the first time I was helped I wrote back asking if I can send a donation, pay for the help etc and they said no. God Bless you folks

 

[p45cal]

It would be under thread tools, but it seems MrExcel hasn't implemented it.

 

[reddcannon]

Thanks and have a wonderful day