Filter Upon Filtered Data

[raindrop]

Hi !
I Want VBA Code To Filter Data By Inputing Date in C2 With Search Button Then I Want Filter Up on Filtered Data
With Just Check Box Selection of Criteria (It Could Be More Than One Check Box Selection).
Herewith Find the Sample Attachment.

Regards
Raindrop

[Rudi]

Hi !
I Want VBA Code To Filter Data By Inputing Date in C2 With Search Button Then I Want Filter Up on Filtered Data
With Just Check Box Selection of Criteria (It Could Be More Than One Check Box Selection).
Herewith Find the Sample Attachment.

Regards
Raindrop

Try this...

[Rudi]

Or you could have a toggle button for the date...

[raindrop]

Solved ! Thank You Very Much Mr. Rudi For Your Kind Help!

[HansV]

Although rudi has already solved your problem, here is yet another possibility - it doesn't use command buttons at all but instead uses the Worksheet_Change event. Simply enter a date in C2 to filter on that date. Clear C2 to remove the date filter.

R-1.xlsm

[raindrop]

Thank You Mr. Hans, Nice Job Without Using Command Button.