Hi Experts,
Is there any way where I could do autofilter customs using text boxes.whatever I enter in text box it should filter in excel sheets those data using Auto filer Customs both numbers and alphabetsl.Does any one have the idea how to do this.
For eg-
Range("A1").Select
Selection.AutoFilter
ActiveSheet.Range("$A$1:$C$4").AutoFilter Field:=2, Criteria1:="=121450", _(the creteria may be number or name or any long discription)
Operator:=xlAnd
In criteria I Would like to appear whatever I type in text boxes i don't want Criteria1:="=*" Because this doesn't filter numbers it filters only test.is there any other way to do it.
Regards
Harsha
Is there any way where I could do autofilter customs using text boxes.whatever I enter in text box it should filter in excel sheets those data using Auto filer Customs both numbers and alphabetsl.Does any one have the idea how to do this.
For eg-
Range("A1").Select
Selection.AutoFilter
ActiveSheet.Range("$A$1:$C$4").AutoFilter Field:=2, Criteria1:="=121450", _(the creteria may be number or name or any long discription)
Operator:=xlAnd
In criteria I Would like to appear whatever I type in text boxes i don't want Criteria1:="=*" Because this doesn't filter numbers it filters only test.is there any other way to do it.
Regards
Harsha
