Dynamic autofilter selection by using Vba

[harinsh]

Hi Team,

I would like to select auto filter with dynamic content text (this will change every time but same column). This is required to integrate into in my main macro, if you can give input box where I can input the required content to filter and same should get filter in the sheet.

The number of contents also varies from time to time....for example if I want to filter content "City" and "PinCode" in given column "A". In this example it's only two contents it may go for 3 or 4 also.

Can anyone help on this.

Thanks,

 

[MisterBates]

Have you tried turning on macro recording, filtering your list then looking at the code that Excel generated?

 

[harinsh]

Yes, I have done it...and not able to customise here....so, looking for help

Here is the recroding code....

ActiveSheet.Range("A:AD").AutoFilter Field:=11, Criteria1:=Array("City","Pincode"), Operator:=xlFilterValues

I would like to customise the content here which hilighed in Bold....

Let me know if you need further clarification....

thanks

 

[MisterBates]

OK. So are you able to anticipate when you might have 1 value vs. 2, 3 or 4?

If not, one option might be to use the inputbox() function to get the input, and have people separate the 2, 3 or 4 values with an agreed character (e.g. put in a list like "City;Pincode"). You can then use the split() function to convert the input string into an array that can be supplied as Criteria1 in the .AutoFilter