advanced filter exact match using vba

[NDMDRB]

Hello,

I'm using advanced filter in a sheet using a list of clientsIDs grabbed from the same sheet. The code works, but a problem arises when I have 2 clientsIDs that start with the same numbers. For example, if one of the clients in my list is 102, my filter also includes 1021. Is there a simple way to adapt the code below to filter exact values from the clientID list? Thanks!

I searched and found that I can use this formula ( ="=102" ) in ws.Range("M5")
But I don't know how to use it in my code below using "Me.cmb_ID.Value" instead of "102"

As this: ws.Range("M5") = (="=Me.cmb_ID.Value")

[/FONT][/COLOR]ws.Range("M5") = Me.cmb_ID.Value
    ws.Range("A4").CurrentRegion.AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=ws.Range( _
        "Criteria_ClientID"), CopyToRange:=ws.Range("Extract_ClientID"), Unique:=False
[COLOR=#242729][FONT=Arial]

 

[mikerickson]

In the Criteria range, if the cell holds "x" (no quotes) it will find any record where that field starts with "x". To find an exact match for x, the criteria cell should hold "=x" (no quotes)

 

[RoryA]

Seems to be the day for this question. You could use:

 With ws.Range("M5")
.Numberformat = "@" ' set Text format
.Value = "=" & Me.cmb_ID.Value
end with

 

[NDMDRB]

Exactly, but my main inquiry is how to use this formula in my code to get the criteria cell =102

 

[NDMDRB]

Thank you so much RoryA, that's what I need

Thank you so much Mike for your time

 

[RoryA]

Glad we could help.