How to add another autofilter to my textbox in excel

  Kiến thức lập trình

I have a DB on excel with a table autofilter using a textbox, i’m trying to add another filter to the same textbox but duplicating the range and field doesn’t work, i’m not an expert in VBA so i need some help to figure out.

nombre = "*" & Sheets("DATOS").TextBox1.Text & "*"
Range("B5").AutoFilter Field:=2, Criteria1:=nombre
Range("C3").AutoFilter Field:=4, Criteria1:=estado


New contributor

Miguel Fonseca is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.