I want vba code that make text box filter exactly number put in it in column e
And any kind of number :
Number store as number
And number store as text
For example
When I type 59
It filter those item which price only 59 not " 599 or 590"
I want vba code that make text box filter exactly number put in it in column e
And any kind of number :
Number store as number
And number store as text
For example
When I type 59
It filter those item which price only 59 not " 599 or 590"
In developer mode, right click that text box, click view code.
Ignore the name of the subprocedure below, copy the contents of that subprocedure into the code window that opens. This will update the filter whenever the text box is changed.
Adjust the columns as desired in the range.
Adjust the name of the textbox that you are using to match the one on the sheet. the name of the textbox should match the name of the sub procedure that is auto generated upon clicking view code in first step above.
Private Sub columnETextBox_Change()
If columnETextBox.Value = "" Then
ActiveSheet.Range("A:H").AutoFilter Field:=5
Else
ActiveSheet.Range("A:G").AutoFilter Field:=5, Criteria1:=columnETextBox.Value
End If
End Sub
Last edited by miamimanni; 07-24-2015 at 11:03 AM.
many thanls is not enouph for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks