Simple filter using VBA/ Active X Control

[tetreama]

Hello. I'd like to use VBA code to filter a data set. This is probably a simple question for most, but I'm a VBA newbie.

I want to use an Active X Control to change the value of cell C2 to 1. If cell C2 is equal to 1, I want my code to filter for 'does not equal' 0. I can set up the Active X Control button. I just need to know what the VBA code should be.

Thanks for your help.

 

[PCL]

Why don't you record a macro when preparing the filter, then assign the macro to the button, the one changing the value of cell C2 to 1.