I created texbox with VBA code is:
Private Sub TextBox1_Change()
Application.ScreenUpdating = False
ActiveSheet.ListObjects("states").Range.AutoFilter Field:=1, Criteria1:="*" & [B3] & "*", Operator:=xlFilterValues
Application.ScreenUpdating = True
End Sub
I linked this text box to cell B3
I want to filter the number . It was not working . I have to choose column B , go to DATA - TEXT TO COLUMN - NEXT - NEXT - choose TEXT - FINISH
Then I have to IGNORE THIS ERROR ( annoying) the whole column B to convert number to TEXT.
But I do not know why EXCEL hide ROW 14, 15 every time I put number 7 in the textbox to filter
Please help me . Can we filter the column B as a Number Value ( I dont need to change whole coumn to TEXT).
AND can someone fix the problem auto hide row like I said above.
Any help would be Appriciated .
Private Sub TextBox1_Change()
Application.ScreenUpdating = False
ActiveSheet.ListObjects("states").Range.AutoFilter Field:=1, Criteria1:="*" & [B3] & "*", Operator:=xlFilterValues
Application.ScreenUpdating = True
End Sub
I linked this text box to cell B3
I want to filter the number . It was not working . I have to choose column B , go to DATA - TEXT TO COLUMN - NEXT - NEXT - choose TEXT - FINISH
Then I have to IGNORE THIS ERROR ( annoying) the whole column B to convert number to TEXT.
But I do not know why EXCEL hide ROW 14, 15 every time I put number 7 in the textbox to filter
Please help me . Can we filter the column B as a Number Value ( I dont need to change whole coumn to TEXT).
AND can someone fix the problem auto hide row like I said above.
Any help would be Appriciated .
1 | ||||||
stt | ||||||
7 | ||||||
NUMBER | TEXT | TEXT2 | TEXT3 | |||
7 | abcd | 6a | abcd | |||
7 | abcd | 6b | abcd | |||