I've been searching all over the Internet and I can't find a definitive answer about whether or not a VBA advanced filter can be activated via the values in one or more data validation list dropdowns.

I currently have the following code but it doesn't work based on the DV lists at all no matter how I modify it. It does run without error and does filter to one specific record each time but doesn't change at all no matter what the DVs are set to. Along with this, I should say that I would also like to make it so the filter icons do not show up on the column headers. If there is any way to tell them to not display, that would be great too.

Sub Set_Filter()

    Application.ScreenUpdating = False

    ActiveSheet.AutoFilterMode = False

' Column B = Field 2
    ActiveSheet.Range("$A$7:$AD$3000").AutoFilter Field:=2, Criteria1:=B3
' Column D = Field 4
    ActiveSheet.Range("$A$7:$AD$3000").AutoFilter Field:=4, Criteria1:=D3
    
    Application.ScreenUpdating = True


End Sub
B3 is the location of the first data validation list and D3 is the location of the 2nd one. I want these to be dynamic so the dropdowns can be changed and then they just push a button to run the above macro to change the current filter to whatever is in the DV dropdown cells. If the filter can be activated just by changing the data selected in the DV, I would consider that the best case scenario if it's at all possible.

Yes, I already know that I could just use the filter from the Home > Editing menu.

Thanks for your help!