Filter with a textbox value

[Mr.Karr]

Hello

Can you please provide a code snippet to filter a column using a textbox value?
or you can also modify the below snippet.

ActiveSheet.ListObjects(1).Range.AutoFilter field:=1, Criteria1:="=*" & Me.TextBox2.Value & "*", Operator:=xlAnd

Please see the attached file.

Many thanks in advance.

 

[Mr.Karr]

any help here pls ?

 

[Deepak]

Hi,

Pls have some patience as we are helping here irrespective of urgency.

Check with attached.

ActiveSheet.ListObjects(1).Range.AutoFilter field:=3, Criteria1:="=*" & Me.TextBox1.Value & "*", Operator:=xlAnd

 

[Mr.Karr]

@Deepak : pls note, what I requested is for Column A pls.
But you edited the existing snippet for column C which I have already. pls advise

 

[Deepak]

Hi,

Column A having dates.
Pls share the sample filter situation in text box.

 

[ThauThème]

Filter with a part of date may be difficult... Can you give some examples of the data you edit on the TexBox1 ?