Excel 2007 : Use Textbox.Value in AutoFilter Criteria (autofilter date)

Hello,

I have the following code generated by autofiltering on a list of date using a text filter "Contains" and then the typed date from , "7/1/2012" and date to "7/3/2012"

Please Login or Register  to view this content.

I would like a search button in my UserForm to activate this code when clicked. The difference is, in place of "date from" and "date to" I would like to have date types in TextBox1 and TextBox2, which would be in the same UserForm as the search button. The following was my attempt at the search button's code:

Please Login or Register  to view this content.

When clicked, I get no errors, and it filters my data, but it doesn't work correctly; all of the rows get filtered out, which must mean that whatever my code's autofilter criteria resolves to, it's not in the column of date. Any ideas on how to write this criteria so that my textbox's value will get used in the filter and how to change the textbox value as date?

The first thing you must do is to the define the appropriate range for your filter, you need the filter only on the first row where the data headers are (if any) For example: B11. Correct this and try your code again.