Autofilter, criteria from InputBox and Wildcard

Hi,

I have created application which relies on a filter. It works, even if not very efficiently, but I have an issue left; I don't know how to use the input from an user for the "contains" filter.
In the example attached, if 'Red' is entered in the InputBox, IDFilterValue returns '*Red*' (syntax for 'contains "Red" '), but Autofilter doesn't work as expected. If '*Red*' is entered as such in the code, as Criteria1, then it works.

I guess that there is something wrong with the variable, as the writing of idfiltervalue is not automatically changed to IDFilterValue. But I couldn't find the answer to my problem in the help.

Any help would be appreciated,
Thank you!

Please Login or Register  to view this content.

TestFilterContain.xlsm

Maybe:

Please Login or Register  to view this content.

Thank you so much!
I can now see how I was approaching this problem exactly the opposite/wrong way.

You're welcome. Glad to help out and thanks for the feedback.