How to filter Listview with numbers

[jqfranco]

Good afternoon
In Excel365 I have a listview with several columns, one of which is sequential numbers. In the table this column is like "Number"
I can filter the listview of all columns, except in this column of sequential numbers.
The criterion is placed in a textbox and I've tried converting it to text and number and it doesn't filter. LView is always clean and on the sheet, hides all lines.

Folha20.ListObjects("BDR_Casas").Range.AutoFilter Field:=1, Criteria1:="=*" & v_Multipage2.TextBox_P02_Casas & "*", Operator:=xlAnd

Thank you for your help.

 

[JEC]

Folha20.ListObjects("BDR_Casas").Range.AutoFilter 1, "*" & v_Multipage2.TextBox_P02_Casas.value & "*"

This is not working either?

 

[jqfranco]

Folha20.ListObjects("BDR_Casas").Range.AutoFilter 1, "*" & v_Multipage2.TextBox_P02_Casas.value & "*"

This is not working either?

It doesn't work either.
If I look for "2" in the sequential numbers column, it hides all the rows, but if I look for "2" in a column formatted as Currency, it works.

 

[JEC]

This has to work, maybe adapt some names, but this is the way

Sub jj()
 With Folha20.ListObjects("BDR_Casas")
   .Range.AutoFilter 1, Filter(Application.Transpose(.DataBodyRange.Columns(1)), CStr(v_Multipage2.TextBox_P02_Casas.Value), True), 7
 End With
End Sub