If a filter is a certain value then...

[gusmspotify]

I have the following sub that is part of a user form to toggle a filter. However there is another button which also toggles a different filter. With the way I have set up the "if then" if I decide to apply the second filter because the AutoFilterMode = True instead of applying the filter I want it removes the filter.

How I have it at the moment is below.

Private Sub Call_Filter_CS_Click()


If sheets("Current").AutoFilterMode = False Then
Call Filters.Filter_Cust
ElseIf sheets("current").AutoFilterMode = True Then
Call Filters.No_Filter


End If


End Sub

 

[Fluff]

Try

ElseIf sheets("current").AutoFilterMode = True Then
sheets("Current").AutoFilterMode = False