Cant search and filter specific number using vba

[handri]

Hi,

whatever i tried. Cant search below number and filter it using vba.

NP ONLINE NEW FORMAT.xlsm
	B	C
1049	1044	885012005010
DATA

others is ok is it any weird things ?

my search vba is ok

Private Sub TextBox1_Change()
    ActiveSheet.ListObjects("TABLE4").Range.AutoFilter Field:=1, _
        Criteria1:="*" & [D2] & "*", Operator:=xlFilterValues
End Sub

Sub clearFilter()
    [D2] = ""
    ActiveSheet.ListObjects("TABLE4").Range.AutoFilter Field:=1
End Sub

 

[Alex Blakenburg]

1) what do you have in D2
2) show us a bit more data and one that does work.
3) Is column B field 1 the of the Table the colouring seems to indicate it may not be part of the table
Wild cards on a number stored as a number won't work

 

[handri]

1) what do you have in D2
2) show us a bit more data and one that does work.
3) Is column B field 1 the of the Table the colouring seems to indicate it may not be part of the table
Wild cards on a number stored as a number won't work

hi

D2

NP ONLINE NEW FORMAT.xlsm
	D
2
DATA

Data works

NP ONLINE NEW FORMAT.xlsm
	C
1013	GM-1A
DATA

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C1074:C1048576,C1:C1048,C1050:C1057	Cell Value	duplicates	text	NO
C6:C1048,C1050:C1073	Cell Value	duplicates	text	NO

B field not part of the table

search not working in this

NP ONLINE NEW FORMAT.xlsm
	C
1049	885012005010
DATA

885012005010

 

[Alex Blakenburg]

How is your data getting into the table ?
The way it looks to me, I would suggest formatting column 1 of your table as text.
If this is acceptable to you then once you have change it to text
To convert your numbers in column 1 to text:-
Data > Text to Columns > Delimited > Clear all delimiters > Text > Finish

Also format D2 as Text.

Let me know your thoughts or how you go with that.

 

[handri]

How is your data getting into the table ?
The way it looks to me, I would suggest formatting column 1 of your table as text.
If this is acceptable to you then once you have change it to text
To convert your numbers in column 1 to text:-
Data > Text to Columns > Delimited > Clear all delimiters > Text > Finish

Also format D2 as Text.

Let me know your thoughts or how you go with that.

Thanks its work. For item unable to search and filter. Convert to text will works.

thanks again

 

[Alex Blakenburg]

Thanks for letting me know. Glad I could help.