vba exact match -- not xlPart

[want2b]

What can I replace xlPart with to cause a search to find an exact match.
Sorry don't have help installed on this machine and search either found too much or none.

 

[Legacy 98055]

xlWhole

also note the MatchCase argument which can be either True or False...

Tom

 

[want2b]

Thank you very much

I had tried Exact and Match that blew up as soon as entered
and All which it took but nothing happened when it ran.

Whole does it

Thanks

 

[pfarmer]

Thank you very much

I had tried Exact and Match that blew up as soon as entered
and All which it took but nothing happened when it ran.

Whole does it

Thanks

This is a VBA search routine I use that is case insensitive:

Set X = ws.Columns(z).Find(Me.TextBox1.Text, after:=ws.Cells(6, z), LookIn:=xlValues, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False)

Perry