I have a user form that sorts a table in excel based off of 3 criterias. all criterias are entered in there own text box in a userform.
the first one is the ID and the 2nd and 3rd criterias are a start number and end number. i want to filter the ID then get all of that ID thats contained between the two numbers. the problem is i dont know how to call upon the textbox and filter between the numbers. heres is the code i can filter the ID.
Sub Macro3()
' Macro3 Macro
ActiveSheet.ListObjects("Table_D04_Roadway_Inventory").Range.AutoFilter Field _
:=3, Criteria1:=Me.TextBox1.Value, Operator:=xlAnd
ActiveSheet.ListObjects("Table_D04_Roadway_Inventory").Range.AutoFilter Field _
:=11, Criteria1:=">=Me.TextBox2.Value", Operator:=xlAnd, Criteria2:="<=Me.TextBox3.Value"
End Sub
this is the part im having trouble with below
ActiveSheet.ListObjects("Table_D04_Roadway_Inventory").Range.AutoFilter Field _
:=11, Criteria1:=">=Me.TextBox2.Value", Operator:=xlAnd, Criteria2:="<=Me.TextBox3.Value"
thanks
Bookmarks